ORA-01111: name for data file string is unknown - rename to
correct file



ORA-01111: name for data file string is unknown - rename to correct file..

Answer / guest

Cause: The data file was missing from a CREATE CONTROLFILE
command or backup controlfile recovery was done with a
controlfile that was saved before the file was created.

Action: Rename the MISSING file to the name of the real file.

Please add more information about this Error

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12562: TNS:bad global handle

1 Answers  


ORA-01688: unable to extend table string.string partition string by string in tablespace string

1 Answers  


TNS-00285: Avg Connect Time (secs) : number

1 Answers  


PCC-02445: USING clause valid only on a PREPAREd dynamic statement

1 Answers  


SQL*Loader-00952: Error calling once/data file initialization

1 Answers  






ORA-16546: missing or invalid piece

1 Answers  


ORA-37014: (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.

1 Answers  


ORA-09767: osnmfs: bad return code from msg_send.

1 Answers  


DGM-16902: Unable to allocate handle

1 Answers  


ORA-30464: no summaries exist

1 Answers  


PLS-00209: table 'string' is not in FROM clause

1 Answers  


RMAN-06188: cannot use command when connected to a mounted target database

1 Answers  


Categories