ORA-19735: wrong creation SCN - control file expects initial 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 ocnvetred adtaflie.

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

Eitehr rsetor ethei nitail vresio nof hte pulgge-din adtaflie, ro cotninu edatbaaser ecoevry,w hic hwil lrecvoer hte cnotro lfil.e

update : 20-08-2017
ORA-19735

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

  • ora-22161 : type code [string] is not valid
  • ora-04068 : existing state of packagesstringstringstring has been discarded
  • ora-25228 : timeout or end-of-fetch during message dequeue from string.string
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-14049 : invalid ALTER TABLE MODIFY PARTITION option
  • ora-03277 : invalid SIZE specified
  • ora-31652 : command response message was invalid type - detaching job
  • ora-02434 : cannot enable unique(string) - unique key not defined for table
  • ora-09978 : skxfqhdel: Error Disconnecting from another endpoint.
  • ora-25185 : index column other than last can not be specified for INCLUDE clause
  • ora-01978 : Missing sequence number
  • ora-12031 : cannot use primary key columns from materialized view log on "string"."string"
  • ora-01535 : rollback segment 'string' already exists
  • ora-06404 : NETCMN: invalid login (connect) string
  • ora-28142 : error in accessing audit index file
  • ora-13189 : recursive SQL parse failed
  • ora-29545 : badly formed class: string
  • ora-13033 : Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
  • ora-12505 : TNS:listener does not currently know of SID given in connect descriptor
  • ora-28170 : unsupported certificate version
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-06531 : Reference to uninitialized collection
  • ora-32591 : connect string too long
  • ora-30375 : materialized view cannot be considered fresh
  • ora-31199 : Warning in processing file string
  • ora-19041 : Comment data cannot contain two consecutive '-'s
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-09975 : kxfspini: Error Initializing SDI Process
  • 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.