Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-19560: %s is not a valid device limit

1 Answers  


NNO-00331: error saving new value string of string to the save config table.

1 Answers  


ORA-25328: %s argument size string is smaller than array size

1 Answers  


IMG-00844: internal image data allocation failed

1 Answers  


ORA-30554: function-based index string.string is disabled

1 Answers  






PCC-02352: out of bounds bind position from PL/SQL

1 Answers  


DGM-16904: Unable to set attribute

1 Answers   TCS,


ORA-01573: shutting down instance, no further change allowed

1 Answers  


ORA-25109: standby lock name space has illegal character 'string'

1 Answers  


ORA-28237: seed length too short

1 Answers  


ORA-29256: Cursor contains both regular and array defines which is illegal

1 Answers  


ORA-25301: cannot specify recipient list during enqueue

1 Answers  






Categories