根据外键名称查找外键所在表的表名

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

ALTERTABLEtable_name

DISABLECONSTRAINTconstraint_name;

select*fromall_constraintswhereowner='SCOTT'andconstraint_name='SYS_C007539';

select*fromall_constraintswhereowner='SCOTT'andconstraint_name='SYS_C007539';