解决方案:
根据需要手动增加目标列以在该列中插入行。
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.
在 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