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



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

Answer / guest

Cause: An attempt was made to insert or update a column with
a value which is too wide for the width of the destination
column. The name of the column is given, along with the
actual width of the value, and the maximum allowed width of
the column. Note that widths are reported in characters if
character length semantics are in effect for the column,
otherwise widths are reported in bytes.

Action: Examine the SQL statement for correctness. Check
source and destination column data types. Either make the
destination column wider, or use a subset of the source
column (i.e. use substring).

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00111: invalid attribute string

1 Answers  


ORA-08102: index key not found, obj# string, file string, block string (string)

1 Answers  


RMAN-06457: UNTIL scn (string) is ahead of last scn in archived logs (string)

1 Answers  


DRG-50800: failed to open cursor

1 Answers  


SQL*Loader-00929: Error parsing insert statement for table string.

1 Answers  






ORA-06042: NETDNT: message receive failure

1 Answers  


ORA-30437: all job queue processes have stopped running

1 Answers  


SQL*Loader-00950: Error shipping data structures across 2-task

1 Answers  


ORA-36612: (XSLMS01) An application attempted to retrieve a non-existent user message. (Product: value, Facility: value, Message Number: value)

1 Answers  


DRG-11116: value of string must be less than or equal to value of string

1 Answers  


LSX-00238: invalid Nmtoken "~S"

1 Answers  


ORA-26084: direct path context already finished

0 Answers  


Categories