drop表时出现ORA-02449: 表中的唯一/主键被外键引用

用select A.*
from user_constraints A, user_constraints B
WHERE b.table_name = ‘TABLE_NAME’
and a.constraint_type = ‘R’
and a.r_constraint_name = b.constraint_name;
查出扎有关联的表，然后删掉！再drop 即可！