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

SQL*Loader-00517: Error decomposing file name (string)

1 Answers  


ORA-04017: invalid value string (length = string) for parameter max_dump_file_size

1 Answers  


DRG-11705: multilevel jump from string to string

1 Answers  


ORA-01945: DEFAULT ROLE[S] already specified

1 Answers  


ORA-16766: Physical apply service unexpectedly offline

1 Answers  






ORA-19208: parameter string of function string must be aliased

1 Answers  


ORA-19773: must specify change tracking file name

1 Answers  


DRG-50853: fetch error

1 Answers  


ORA-09889: osnTXtt: access error on oracle executable

1 Answers  


RMAN-08539: backup set key=string recid=string stamp=string

1 Answers  


ORA-13630: The task string contains execution results and cannot be executed.

1 Answers  


ORA-02726: osnpop: access error on oracle executable

1 Answers  


Categories