关于 Oracle DB CONSTRAINT约束的一些SQL ORA-02292: integrity constraint violated

ALTER TABLE table_name
DISABLE CONSTRAINT constraint_name;
select * from all_constraints
     where owner = 'SCOTT'
     and constraint_name = 'SYS_C007539';

 

select*from all_constraints
     where owner ='SCOTT'and constraint_name ='SYS_C007539';
posted @ 2016-12-16 14:18  johnsonshu  阅读(750)  评论(0编辑  收藏  举报