1.禁用外键:
select 'ALTER table ' || table_name || ' disable constraint ' || c.constraint_name from user_constraints c where c.constraint_type='R'
2.删除表数据:
select 'truncate table ' || s.table_name || ';' from user_all_tables s;
3.启用外键:
select 'ALTER table ' || table_name || ' enable constraint ' || c.constraint_name ||';' from user_constraints c where c.constraint_type='R';