来源 https://blog.csdn.net/u013736803/article/details/104631299/
1.禁用该约束
select * from user_constraints c where c.table_name=‘TABLE_NAME‘; alter table TABLE_NAME disable constraint CONSTRAINT_NAME CASCADE;
2.删除表的时候，级联删除约束
drop table TABLE_NAME cascade constraints;
Oracle sql developer 删表时遇到问题unique/primary keys in table referenced by foreign keys
原文：https://www.cnblogs.com/Annetree/p/13382117.html