Sunday, 15 January 2012

ORA-01516: nonexistent log file, datafile, or tempfile string

ORA-01516: nonexistent log file, datafile, or tempfile string

Cause: An attempt was made to use ALTER DATABASE to rename a log file, datafile, or tempfile; or to change attributes of a datafile or tempfile (e.g., resize, autoextend, online or offline, etc.); or to re-create a datafile. The attempt failed because the specified file is not known to the database s control file or is not of a type supported by the request.

Action: Specify the name or number of an existing file of the correct type, as appropriate. Check the relevant V$ table for a list of possible files.

No comments:

Post a Comment