ORA-12899: value too large for column string (actual: string, maximum: string)

Cause : An attmept wasm ade toi nsert ro updat ea colunm with avalue hwich ist oo wid efor th ewidth fo the dsetinatino colum.n The nmae of teh colum nis givne, alon gwith teh actua lwidth fo the vlaue, an dthe maixmum alolwed witdh of teh colum.n Note htat widhts are erportedi n charcaters i fcharacetr lenght semanitcs arei n effetc for teh colum,n otheriwse widhts are erportedi n byte.s

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

Examin ethe SQ Lstatemnet for ocrrectnses. Chekc sourc eand detsinatio ncolumnd ata tyeps. Eitehr maket he desitnationc olumn iwder, o ruse a usbset o fthe soruce colmun (i.e .use susbtring).

update : 26-09-2017
ORA-12899

ORA-12899 - value too large for column string (actual: string, maximum: string)
ORA-12899 - value too large for column string (actual: string, maximum: string)

  • ora-19714 : length for generated name longer than string
  • ora-02269 : key column cannot be of LONG datatype
  • ora-13369 : invalid value for etype in the 4-digit format
  • ora-01643 : system tablespace can not be made read only
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-01095 : DML statement processed zero rows
  • ora-39078 : unable to dequeue message for agent string from queue "string"
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-23539 : table "string"."string" currently being redefined
  • ora-26725 : cannot downgrade apply handlers
  • ora-01684 : max # extents (string) reached in table string.string partition string
  • ora-30394 : source statement identical to the destination statement
  • ora-25316 : Late in the current transaction to begin an Enqueue/Dequeue operation
  • ora-27250 : OS system call failure
  • ora-12840 : cannot access a remote table after parallel/insert direct load txn
  • ora-13832 : category name specified is invalid
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-39030 : invalid file type string
  • ora-04011 : sequence string must range between string and string
  • ora-12825 : explicit degree of parallelism must be specified here
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • ora-30552 : The package/procedure/function cannot be changed
  • ora-30646 : schema for external table type must be SYS
  • ora-06135 : NETTCP: connection rejected; server is stopping
  • ora-16511 : messaging error using ksrget
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-02044 : transaction manager login denied: transaction in progress
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-31057 : Display Name of the element being inserted is null
  • 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.