How to Fix ORA-12899: value too large

The other day I was installing Peopletools on a Linux instance when I came across this error and I am sure some body else also might get stuck at this stage so i would like to post the solution for this error.

 
Error:
SQL Error. Error position: 129 Return: 12899 - ORA-12899: value too large for column "SYSADM". "PS_CAN_GOV_COUNTRY". "DESCR" (actual: 33, maximum: 30)
Error: Unable to insert row 280
Error: SQL execute error for CAN_GOV_COUNTRY
Unsuccessful Completition

Solution:

Increase the destination column manually as required to insert the rows in that column.
sql>desc PS_CAN_GOV_COUNTRY;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
CAN_COUNTRY_CD                            NOT NULL VARCHAR2(5 CHAR)
EFFDT                                     NOT NULL DATE
EFF_STATUS                                NOT NULL VARCHAR2(1 CHAR)
DESCR                                     NOT NULL VARCHAR2(30 CHAR)
DESCRSHORT                                NOT NULL VARCHAR2(10 CHAR)

sql> alter table PS_CAN_GOV_SCHOOL modify DESCR VARCHAR2(35);
Table altered.

sql> commit;
Commit complete.

Leave a Comment