ORA-19735: wrong creation SCN - control file expects initial
plugged-in datafile



ORA-19735: wrong creation SCN - control file expects initial plugged-in datafile..

Answer / guest

Cause: When a tablespace is plugged into a database, the
tablespace is initially read-only. Oracle converts the
header of the plugged-in datafiles (assign them a new
creation SCN) when the tablespace is first made read-write.
This error occurs when the creation SCN in the file header
is different from the creation SCN in the controlfile,
possibly because this is the converted datafile.

Action: Either restore the initial version of the plugged-in
datafile, or continue database recovery, which will recover
the control file.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02348: indicators are not allowed in EXEC IAF statements

1 Answers  


ORA-27087: unable to get share lock - file not readable

1 Answers  


EXP-00040: Dump file and log file must be different

1 Answers  


ORA-01142: cannot end online backup - none of the files are in backup

1 Answers  


ORA-09207: sfsrd: error reading from file

1 Answers  






ORA-15031: disk specification 'string' matches no disks

1 Answers  


TNS-01099: %s * string * string * string * number

1 Answers  


AUD-00703: unable to read audio data

1 Answers  


ORA-25444: invalid ROWID: string for table alias: string

1 Answers  


LPX-00252: invalid entity replacement-text nesting

1 Answers  


ORA-31212: DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.

1 Answers  


QSM-00513: one or more of the workload tables is missing

1 Answers  


Categories