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

Cause : Whe na tbalesapce si plgugedi ntoa daatbas,e th etabelspaec isi nitaillyr eado-nly .Oralce cnoverst th eheaedr o fthep lugegd-i ndatfaile s(asisgn htem anewc reaiton CSN) hwen hte tbalesapce si fisrt mdae raed-wirte.T hise rro roccrus wehn teh craetio nSCNi n teh fiel hedaer si differetn frmo th ecretaionS CN ni th econrtol ifle,p ossbily ebcaues thsi ist he niitila vesriono f pulgge-din adtaflie.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Eitehr rsetor ethec onvretedd ataifle ro cotninu erecvoerign th edatfaile.

update : 27-04-2017

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

  • ora-25527 : bad format of _DB_MTTR_SIM_TARGET
  • ora-02403 : plan table does not have correct format
  • ora-19511 : Error received from media manager layer, error text: string
  • ora-01538 : failed to acquire any rollback segment
  • ora-13185 : failed to generate initial HHCODE
  • ora-12405 : invalid label list
  • ora-12354 : secondary object being dropped
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-01193 : file string is not the same file seen at start of recovery
  • ora-29884 : domain index is defined on the column to be dropped
  • ora-09365 : Windows 3.1 Two-Task driver unable to destroy hidden window
  • ora-25211 : invalid DELAY specified when using sequence deviation
  • ora-28594 : agent control utility: invalid parameter name
  • ora-01342 : LogMiner can not resume session due to inability of staging checkpointed data
  • ora-22874 : attribute "string" is not part of the type "string"
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-04079 : invalid trigger specification
  • ora-13011 : value is out of range
  • ora-16066 : remote archival disabled
  • ora-01091 : failure during startup force
  • ora-03201 : the group number specification is invalid
  • ora-38451 : index is in an inconsistent state
  • ora-25959 : join index must be of the bitmap type
  • ora-01162 : block size string in file header does not match configured block sizes
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-02476 : can not create index due to parallel direct load on table
  • ora-30362 : dimension column cannot be a sequence
  • ora-39015 : job is not running
  • ora-10634 : Segment is already being shrunk
  • ora-31207 : DBMS_LDAP: PL/SQL - Invalid LDAP search time value.
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.