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-13421: null or invalid cell value

1 Answers  


ORA-07345: The datafile name must not contain the string '..'.

1 Answers  


ORA-36906: (XSAGDNGL45) 4. Model only includes one non-step dimension in the equations.

1 Answers  


ORA-33280: (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.

1 Answers  


ORA-09711: orasrv: archmon already connected.

1 Answers  






NNO-00160: warning: ignoring duplicate hint server "string"

1 Answers  


ORA-02045: too many local sessions participating in global transaction

1 Answers  


ORA-12405: invalid label list

1 Answers  


ORA-12017: cannot alter primary key mview 'string' to a rowid mview

1 Answers  


ORA-07587: spdcr: $CREPRC failure

1 Answers  


ORA-15106: missing or invalid operating system disk locator string

1 Answers  


ORA-06568: obsolete ICD procedure called

1 Answers  


Categories