ORA-02443: Cannot drop constraints - nonexistent constraint

SQL报错如下：

SQL> alter table dbtrade.QRTZ_TRIGGERS drop constraints QRTZ_CRON_TRIGGERS_ibfk_1;

ERROR at line 1:
ORA-02443: Cannot drop constraint  - nonexistent constraint
复制

要加双引号：

SQL> alter table dbtrade.QRTZ_TRIGGERS drop constraints "QRTZ_CRON_TRIGGERS_ibfk_1";

Table altered.
复制

参考链接：
https://www.plsql.co/ora-02443-cannot-drop-constraint.html