ORA-02449: unique/primary keys in table referenced by foreign keys
如果drop表的時候 發生了02449
→要先找出正要刪的表 被哪個外來鍵引用
SELECT A.*
FROM user_constraints A,
user_constraints B
WHERE b.table_name = '表名'
AND a.constraint_type = 'R'
AND a.r_constraint_name = b.constraint_name;
沒有留言:
張貼留言