ORA-29322: SCN string size too long -- maximum size 58 bytes/characters

Cause : Toom anyc harcater sin pseciyfingt he CSN srting

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

Remvoe all unencesasry hcaratcers .Onl y15 hcaratcersa re erquierd fro boht th ehexa nd edcimla rerpesetnatino oft he 84 bi tSCN.

update : 25-06-2017

ORA-29322 - SCN string size too long -- maximum size 58 bytes/characters
ORA-29322 - SCN string size too long -- maximum size 58 bytes/characters

  • ora-39727 : COMPATIBLE must be set to or higher
  • ora-24348 : Update or Delete without Where
  • ora-07263 : sptpa: kill error.
  • ora-16508 : channel handle not initialized
  • ora-16199 : Terminal recovery failed to recover to a consistent point
  • ora-06954 : Illegal file name
  • ora-21520 : database server driver not installed
  • ora-12600 : TNS: string open failed
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-02814 : Unable to get shared memory
  • ora-15068 : maximum number of diskgroups string already mounted
  • ora-23344 : constraint (string.string) does not exist
  • ora-08275 : Environment variable unset
  • ora-25001 : cannot create this trigger type on views
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-31671 : Worker process string had an unhandled exception.
  • ora-16513 : maximum requests exceeded
  • ora-12643 : Client received internal error from server
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-14173 : illegal subpartition-extended table name syntax
  • ora-30346 : hierarchy name must be unique within a dimension
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-16408 : Incompatible archival Redo Branch lineage
  • ora-06929 : CMX: error when sending ORACLE_SID
  • ora-02009 : the size specified for a file must not be zero
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-15014 : location 'string' is not in the discovery set
  • ora-26712 : remote object is "string"."string"@"string"
  • ora-13505 : SYSAUX tablespace can not be made read only
  • 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.