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


ORA-01173: data dictionary indicates missing data file from
system tablespace



ORA-01173: data dictionary indicates missing data file from system tablespace..

Answer / guest

Cause: Either the database has been recovered to a point in
time in the future of the controlfile or a datafile from the
system tablespace was omitted from the create controlfile
command previously issued.

Action: For the former problem you need to recover the
database from a more recent controlfile. For the latter
problem, simply recreate the controlfile checking to be sure
that you include all the datafiles in the system tablespace.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06207: WARNING: string objects could not be deleted for string channel(s) due

1 Answers  


ORA-13188: cell decode failed

1 Answers  


ORA-22972: NULL value not allowed in PRIMARY KEY-based object identifier

1 Answers  


RMAN-05002: aborting point-in-time tablespace recovery

1 Answers  


ORA-03214: File Size specified is smaller than minimum required

1 Answers  






RMAN-20202: tablespace not found in the recovery catalog

1 Answers  


NNO-00120: line string: topology name "string" not allowed here

1 Answers  


ORA-09771: osnmwrtbrkmsg: bad return code from msg_send.

1 Answers  


ORA-08005: specified row does not exist

1 Answers  


ORA-12417: database object "string" not found

1 Answers  


ORA-01109: database not open

1 Answers  


ORA-34344: (MXDSS03) Analytic workspace string is not attached.

1 Answers  






Categories