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;
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;