ORA-01182: cannot create database file string - file is in
use or recovery



ORA-01182: cannot create database file string - file is in use or recovery..

Answer / guest

Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to
recreate a datafile that is online in an open instance or is
being recovered.

Action: Close database in all instances and end all recovery
sessions

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24810: attempting to write more data than indicated

1 Answers  


QSM-02063: aggregate function in mv

1 Answers  


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

1 Answers  


NPL-00300: maximum ASN.1 element nesting depth string exceeded on read

1 Answers  


SQL*Loader-00916: Error checking path homogeneity

1 Answers  






ORA-35078: (QFHEAD05) An EIF extension file header for string is not in the correct format.

1 Answers  


ORA-01934: circular role grant detected

1 Answers  


SQL*Loader-00558: attempt to use SKIP parameter with linked-in loader

1 Answers  


ORA-13435: GeoRaster metadata dimension inconsistent

1 Answers  


IMP-00025: for DBA export files, FROMUSER must be specified with TOUSER option

1 Answers  


ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.

1 Answers  


SQL*Loader-00626: Character set conversion buffer overflow.

1 Answers  


Categories