ORA-22065: number to text translation for the given format causes overflow

Cause : oRnuidgnd no eud eott ehg vines rtni gofmrtac uaes svorelfwo.

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

hCnaegt ehs rtni gofmrtas cu hhttao evfrol wodsen too ccru.

update : 28-05-2017
ORA-22065

ORA-22065 - number to text translation for the given format causes overflow
ORA-22065 - number to text translation for the given format causes overflow

  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-30378 : MV_CAPABILITIES_TABLE is not compatible with Oracle version
  • ora-38438 : getVarchar not possible due to "string" datatype in the attribute set
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-16133 : Datafile string has incorrect terminal recovery stamp.
  • ora-12689 : Server Authentication required, but not supported
  • ora-09843 : soacon: Archmon unable to create named pipe.
  • ora-02205 : only SELECT and ALTER privileges are valid for sequences
  • ora-02056 : 2PC: string: bad two-phase command number string from string
  • ora-31690 : Process name buffer size must be specified and must be greater than 0.
  • ora-28239 : no key provided
  • ora-30447 : internal data for run number string is inconsistent
  • ora-12632 : Role fetch failed
  • ora-02285 : duplicate START WITH specifications
  • ora-01197 : thread string only contains one log
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-21610 : size [string] is invalid
  • ora-00912 : input parameter too long
  • ora-28026 : user with same external name already exists
  • ora-03219 : Tablespace 'string' is dictionary-managed, offline or temporary
  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • ora-08446 : syntax error in SYNCHRONIZED clause in mask options
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-32700 : error occurred in DIAG Group Service
  • ora-15041 : diskgroup space exhausted
  • ora-16547 : cannot disable the primary database
  • ora-34179 : (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE.
  • ora-09969 : unable to close or remove lock file
  • ora-32743 : command cannot be executed on remote instance
  • 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.