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 : 30-04-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-29327 : unsupported client compatibility mode used when talking to the server
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-12817 : parallel query option must be enabled
  • ora-12351 : cannot create view using a remote object which has a remote object reference
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-16630 : that database property was deprecated
  • ora-36952 : (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.
  • ora-02463 : Duplicate HASH IS option specified
  • ora-09206 : sfrfb: error reading from file
  • ora-09718 : osnsui: cannot set up user interrupt handler.
  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-25955 : all tables must be joined in the where clause
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-13442 : GeoRaster metadata SRS error
  • ora-33449 : (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-25962 : join index prevents multitable insert or merge
  • ora-22602 : pickler TDS handle [string] is not well-formed
  • ora-13629 : The task or object string is being used by another operation.
  • ora-12156 : TNS:tried to reset line from incorrect state
  • ora-38502 : invalid XML tag: string
  • ora-16117 : processing
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-16119 : building transaction at SCN string
  • ora-31648 : Timeout before master process string finished initialization.
  • ora-31053 : The value of the depth argument in the operator cannot be negative
  • ora-07412 : sfaslv: Error getting entry in asynchronous write array.
  • ora-01649 : operation not allowed with a backup control file
  • ora-30363 : columns in a dimension column list must be in the same relation
  • 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.