ORA-19734: wrong creation SCN - control file expects
converted plugged-in datafile



ORA-19734: wrong creation SCN - control file expects converted 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 initial version of plugged-in
datafile.

Action: Either restore the converted datafile or continue
recovering the datafile.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00019: maximum number of session licenses exceeded

1 Answers  


ORA-19705: tag value exceeds maximum length of string characters

1 Answers  


ORA-06133: NETTCP: file not found

1 Answers  


ORA-24305: bad bind or define context

1 Answers  


ORA-01214: MAXLOGHISTORY may not exceed string

1 Answers  


KUP-04091: little endian byte order mark found when big endian expected in string

1 Answers  


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

1 Answers  


PLS-00594: the SELF parameter can be declared only as IN or as IN OUT

2 Answers  


ORA-32050: %s operation failed

1 Answers  


ORA-00099: timed out while waiting for resource, potential PDML deadlock

1 Answers  


TNS-00113: Failed to open error log file

1 Answers  


NID-00123: Magic number for datafile "string" is incorrect

1 Answers  


Categories