SELECT 'ALTER TABLE ' || table_name || ' disable CONSTRAINT ' || constraint_name || ';' FROM user_constraints where CONSTRAINT_TYPE = 'R';
拿到的结果全部执行一遍
然后当前用户下所有表
begin for t in (select table_name from user_tables) loop execute immediate 'drop table '||t.table_name; end loop; end;