ORA-12987: cannot combine drop column with other operations ORACLE 报错 故障修复 远程处理
文档解释
ORA-12987: cannot combine drop column with other operations
Cause: An attempt was made to combine drop column with other ALTER TABLE operations.
Action: Ensure that drop column is the sole operation specified in ALTER TABLE.
ORA-12987:不能与其他操作组合使用DROP COLUMN。
官方解释
常见案例
ALTER TABLE customer ADD a VARCHAR2(20) NOT NULL, DROP COLUMN b;
正常处理方法及步骤
ALTER TABLE customer DROP COLUMN b, ADD a VARCHAR2(20) NOT NULL;