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

TNS-01023: Version string

1 Answers  


ORA-39707: compatibile parameter string too high for downgrade to string

1 Answers  


PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin

1 Answers  


ORA-29386: plan or consumer group string is mandatory and cannot be deleted or modified

1 Answers  


LPX-00281: unsupported encoding "~s"

1 Answers  






ORA-22862: specified object identifier doesn't match existing object identifier

1 Answers  


ORA-39085: cannot update job string for user string

1 Answers  


SQL*Loader-00954: Error shipping index to read buffer across 2-task

1 Answers  


ORA-37010: (XSACQUIRE_DIFFAW) When using CONSITENT WITH clause, all objects must come from the same analytic workspace.

1 Answers  


ORA-12809: cannot set string_INSTANCES when mounted in exclusive mode

1 Answers  


ORA-00329: archived log begins at change string, need change string

1 Answers  


ORA-31084: error while creating table "string"."string" for element "string"

1 Answers  


Categories