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-12443: policy not applied to some tables in schema

1 Answers  


ORA-16753: Resource guard could not open standby database

1 Answers  


DRG-10756: neither text indexing nor theme indexing has been selected

1 Answers  


LFI-00106: Path object holds more than one path.

1 Answers  


ORA-09283: sllfsk: error skipping records

1 Answers  


ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition

1 Answers  


ORA-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.

1 Answers  


ORA-29544: invalid type

1 Answers  


ORA-25017: cannot reference NEW ROWID for movable rows in before triggers

1 Answers  


ORA-07608: szprv: $GETUAI failure

1 Answers  


ORA-01315: Log file has been added or removed during select

1 Answers  


LPX-00112: element "~S" has multiple ID attributes

1 Answers  


Categories