You are here: Home // Oracle 11g // ORA-19734: wrong creation SCN – control file expects converted plugged-in datafile

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

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 control file, possibly because this is the initial version of plugged-in datafile. See the solution below.

Error solution: Either restore the converted datafile or continue recovering the datafile.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: Paradyż Piumetta gabinet stomatologiczny rzeszów transfer price poland artykuły reklamowe Filtr Fiaam TOYOTA HI-ACE (Fiaam)