解决方案:

根据需要手动增加目标列以在该列中插入行。

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.
如何修复 ORA-12899: 值太大

在 Linux 实例上安装 Peopletools 时报错 ORA-12899: value too large。

错误:

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
日期:2020-06-02 22:18:36 来源:oir作者:oir