清空所用表

select 'alter trigger "' || tr.trigger_name || '" disable;'
  from user_triggers tr
 where substr(tr.trigger_name, 0, 4) <> 'BIN$'
 order by tr.trigger_name;

select 'alter table ' || u.table_name || ' disable constraint ' ||
       u.constraint_name || ';' as SQLS
  from user_constraints u
 where owner = user
   and u.constraint_type = 'R'
 order by u.constraint_name;

select 'truncate table ' || t.table_name || ';' as TRUN
  from user_all_tables t
  where lower(t.table_name) not in
  ('option_name', 'linkman_kind','department_type','department','district_type','district','sync_interface','industry_info','enterprise_property'
  ,'organise_reach','customer_potential','individuation_requirement','pay_term',
  'area_queue_map',
  'syncolumn','syncolvaluemap','synctable','sync_interface','sync_rollback_log')
 and lower(t.table_name) not in(
 select distinct lower(table_name) from option_name)
 
 order by t.table_name;

select 'alter table ' || u.table_name || ' enable constraint ' ||
       u.constraint_name || ';' as SQLS
  from user_constraints u
 where owner = user
   and u.constraint_type = 'R'
 order by u.constraint_name;
 
 
 select 'alter trigger "' || tr.trigger_name || '" enable;'
  from user_triggers tr
 where substr(tr.trigger_name, 0, 4) <> 'BIN$'
 order by tr.trigger_name;