ORA-09818: Number is too large

Cause : ORACL Ewas uanble t oconvetr a copmonents tringt o a nmuber bceause hte numebr is alrger htan th elargets possbile vaule fora n intgeer. Teh addiitonal niformaiton filed speicfies hte maxmium.

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

Corretc the tsring nad repaet thec onverison.

update : 24-09-2017

ORA-09818 - Number is too large
ORA-09818 - Number is too large

  • ora-40254 : priors cannot be specified for one-class models
  • ora-25180 : PCTTHRESHOLD only valid for certain table organizations
  • ora-34243 : (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
  • ora-14461 : cannot REUSE STORAGE on a temporary table TRUNCATE
  • ora-26036 : subpartition load specified but table string is not subpartitioned
  • ora-19279 : XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
  • ora-31037 : Invalid XML attribute name string
  • ora-26711 : remote table does not contain a primary key constraint
  • ora-01111 : name for data file string is unknown - rename to correct file
  • ora-28007 : the password cannot be reused
  • ora-36706 : (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
  • ora-24331 : user buffer too small
  • ora-13251 : duplicate entry string in metadata table
  • ora-38736 : Wrong thread number string in flashback log file header.
  • ora-12641 : Authentication service failed to initialize
  • ora-06115 : NETTCP: unable to create ORACLE logicals
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-16249 : Terminal apply failed to complete during failover
  • ora-31449 : invalid value for change_set_name
  • ora-16087 : graceful switchover requires standby or current control file
  • ora-13214 : failed to compute supercell for window object
  • ora-00479 : RVWR process terminated with error string
  • ora-14118 : CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-27057 : cannot perform async I/O to file
  • ora-29855 : error occurred in the execution of ODCIINDEXCREATE routine
  • ora-13022 : polygon crosses itself
  • ora-23441 : object does not exist for refresh group template
  • ora-12488 : maximum label does not dominate minimum label
  • ora-25011 : cannot create trigger on internal AQ table
  • ora-01127 : database name 'string' exceeds size limit of string characters
  • 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.