禁用当前用户下的全部约束

select 'alter table ' || table_name || ' disable constraint ' ||

constraint_name || ';'

from user_constraints

where constraint_type = 'R';

生成清空所有表中的数据的语句

select 'truncate table '||table_name||';' from user_tables;

生成删除所有表的语句

select 'drop table '||table_name||';' as sqlscript from user_tables;

删除当前用户下所有的sequence

select sequence_owner, 'drop sequence' || sequence_name || ';' as sqlscript from dba_sequences where sequence_owner = '你的用户名'

启用数据库中所有表的约束

select 'alter table ' || table_name || ' enable constraint ' ||

constraint_name || ';'

from user_constraints

where constraint_type = 'R';