ORA-22054: underflow error

Cause : This oeprations' resul tis belwo the rnage of rOacle nmuber.

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

Increaes the ipnut valeu(s) sot hat th eresulti s in teh rangeo f Oracel numbe.r

update : 24-05-2017

ORA-22054 - underflow error
ORA-22054 - underflow error

  • ora-37010 : (XSACQUIRE_DIFFAW) When using the CONSISTENT WITH clause, all objects must come from the same analytic workspace.
  • ora-23610 : internal dbms_streams_tablespaces error: [string] [string] [string] [string]
  • ora-09874 : TASDEF_READ: read error, unable to read tasdef@.dbf file.
  • ora-36391 : (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
  • ora-30131 : number of keys being set exceeds allocation
  • ora-14553 : cannot perform a lob write operation inside a query
  • ora-07419 : sfareq: Database writer got error in timing function.
  • ora-01999 : password file cannot be updated in SHARED mode
  • ora-25282 : message id. not provided for non-repudiation
  • ora-06579 : Bind variable not big enough to hold the output value
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-00360 : not a logfile member: string
  • ora-22998 : CLOB or NCLOB in multibyte character set not supported
  • ora-19265 : XQ0045 - invalid or unknown prefix string in function declaration
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-25123 : Too many components specified in the name.
  • ora-06407 : NETCMN: unable to set up break handling environment
  • ora-38737 : Expected sequence number string doesn't match string
  • ora-07499 : spglk: Cannot reschedule.
  • ora-30398 : illegal JOIN KEY clause
  • ora-00094 : %s requires an integer value
  • ora-02055 : distributed update operation failed; rollback required
  • ora-31536 : cannot support encrypted column string in the source table
  • ora-28353 : failed to open wallet
  • ora-12350 : database link being dropped is still mounted
  • ora-02181 : invalid option to ROLLBACK WORK
  • ora-22862 : specified object identifier doesn't match existing object identifier
  • ora-02267 : column type incompatible with referenced column type
  • ora-19203 : Error occurred in DBMS_XMLGEN processingstring
  • ora-12081 : update operation not allowed on table "string"."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.