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

ORA-06006: NETASY: dialogue execute failure

1 Answers  


PCC-02012: did not find matching quote for char constant

1 Answers  


NCR-04012: NCRR: Invalid address descriptor

1 Answers  


ORA-12235: TNS:Failure to redirect to destination

1 Answers  


ORA-31652: command response message was invalid type - detaching job

1 Answers  


ORA-19910: can not change recovery target incarnation in controlfile

1 Answers  


ORA-07682: sou2os: set kernel dispatch fail err

1 Answers  


SQL-02121: Invalid host name

1 Answers  


ORA-07671: $IDTOASC failed translating an integrity category

1 Answers  


ORA-16146: standby destination control file enqueue unavailable

1 Answers  


PLS-00363: expression 'string' cannot be used as an assignment target

1 Answers  


ORA-27547: Unable to query IPC OSD attribute string

1 Answers  


Categories