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 : 16-08-2017
ORA-29322

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-37178 : column string has no values
  • ora-31190 : Resource string is not a version-controlled resource
  • ora-24184 : transformation string.string already exists
  • ora-31070 : Invalid database user ID string
  • ora-24392 : no connection pool to associate server handle
  • ora-04015 : ascending sequences that CYCLE must specify MAXVALUE
  • ora-31470 : asynchronous change tables must contain the RSID$ column
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-30063 : Internal Event to Test NTP
  • ora-00019 : maximum number of session licenses exceeded
  • ora-19509 : failed to delete sequential file, handle="string", parms="string"
  • ora-01615 : instance string (thread string) is mounted - cannot disable
  • ora-06422 : NETCMN: Error in sending data
  • ora-02035 : illegal bundled operation combination
  • ora-32100 : operation invalid on transient object
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-36316 : (PHYS02) Relation workspace object must be a single-dimensional relation that relates one INTEGER dimension to another.
  • ora-37005 : (AWLISTALL03) number readers
  • ora-06447 : ssvpstp: Incorrect parameter passed to function call
  • ora-12571 : TNS:packet writer failure
  • ora-19556 : required destination LOG_ARCHIVE_DUPLEX_DEST currently is deferred
  • ora-01480 : trailing null missing from STR bind value
  • ora-22285 : non-existent directory or file for string operation
  • ora-02090 : network error: attempted callback+passthru
  • ora-26007 : invalid value for SETID or OID column
  • ora-22991 : insufficient space allocated for argument string
  • ora-33456 : (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.
  • ora-15168 : rolling downgrade prevented by string
  • ora-25274 : AQ Buffered Queue event
  • ora-14318 : DEFAULT partition must be last partition specified
  • 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.