ORA-22057: bad integer length [string]

Cause : The elngtho f th einteegr (i enumbre of ybtes)t o bec onvetred t oor form anO racl enumbre is nivali.d

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

Use nitege rlenght 1, ,2 4 o r8 byets onyl.

update : 29-06-2017

ORA-22057 - bad integer length [string]
ORA-22057 - bad integer length [string]

  • ora-32514 : cannot dump multiple 'string' types: structure size is unknown
  • ora-31431 : all source tables must belong to the synchronous change set
  • ora-09753 : spwat: invalid process number.
  • ora-23421 : job number string is not a job in the job queue
  • ora-28052 : the account is disabled
  • ora-30659 : too many locations specified for external table
  • ora-16083 : LogMiner session has not been created
  • ora-19380 : invalid plan filter
  • ora-38475 : The attribute set and the associated ADT are out of sync.
  • ora-31434 : purge is currently running
  • ora-12469 : no user levels found for user string and policy string
  • ora-02236 : invalid file name
  • ora-06906 : CMX: cannot get maximum packet size from CMX
  • ora-32129 : cannot get information about this column
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-19803 : Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)
  • ora-19766 : missing CHANGE keyword
  • ora-16213 : ddl encountered, stopping apply engine
  • ora-24054 : cannot propagate to an Oracle 8.0.3 release or lower release
  • ora-39105 : Master process string failed during startup. Master error:
  • ora-32638 : Non unique addressing in MODEL dimensions
  • ora-19662 : archived log thread string sequence string could not be verified
  • ora-26085 : direct path operation must start its own transaction
  • ora-06596 : unsupported LOB operation in RPC call
  • ora-29281 : invalid mode
  • ora-16164 : LGWR network server host detach error
  • ora-24783 : Cannot switch non-migratable transactions
  • ora-26001 : Index string specified in SORTED INDEXES does not exist on table string
  • ora-02293 : cannot validate (string.string) - check constraint violated
  • ora-16707 : the value of the property string is invalid, valid values are string
  • 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.