查出当前用户带外键的表select OWNER,TABLE_name from user_cons_columns where constraint_name in (select constraint_name from user_constraints where constraint_type = 'R');查出当前用户带外键的表select TABLE_name from user_cons_columns where constraint_name in (select constraint_name from user_constraints where constraint_type = 'R');查出所有用户带外键的表select OWNER,TABLE_name from all_cons_columns where constraint_name in (select constraint_name from all_constraints where constraint_type = 'R');查出部分用户带外键的表select OWNER,TABLE_name from all_cons_columns where constraint_name in (select constraint_name from all_constraints where constraint_type = 'R' and owner in('MP','MP1'));
找到后再屏蔽掉外键查出当前用户带外键的表select TABLE_name from user_cons_columns where constraint_name in (select constraint_name from user_constraints wh查出所有用户带外键的表select TABLE_name from all_cons_columns where constraint_name in (select constraint_name from all_constraints where constraint_type = 'R');ere constraint_type = 'R');