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



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

Answer / guest

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/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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07265: sppst: semop error, unable to increment semaphore.

1 Answers  


ORA-30088: datetime/interval precision is out of range

1 Answers  


ORA-06550: line string, column string: string

1 Answers  


ORA-19621: archivelog range has already been specified

1 Answers  


ORA-12315: database link type is invalid for the ALTER DATABASE statement

1 Answers  






NZE-29018: The premaster secret contains an incorrect version number.

1 Answers  


NNO-00626: cannot enable DEFAULT-FORWARDERS-ONLY mode, no default forwarders exist

1 Answers  


LPX-00272: FTP server unavailable: ~s

1 Answers  


RMAN-10022: error in system-dependant sleep routine

1 Answers  


TNS-12665: NLS string open failed

1 Answers  


ORA-29274: fixed-width multibyte character set not allowed for a URL

1 Answers  


ORA-31105: User does not own lock "string"

1 Answers  


Categories