ORA-12899: value too large for column string ... - Oracle Database 12c Error Messages
In this video we are going to see how to fix below Oracle Database 12c Error Message.
ORA-12899: value too large for column string (actual: string, maximum: string).
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).
#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database