set echo off
set pages 0
set feedback off
set verify off
set define off
set lines 200

-- Disable constraints
prompt -- Disable Constraints
set termout off
spool cons_off.sql
select 'alter table ' || table_name || ' disable constraint ' || constraint_name || ';' from user_constraints where constraint_type='R';
spool off
set termout on
start cons_off

-- Disable triggers
prompt -- Disable Triggers
set termout off
spool trigs_off.sql
select 'alter table ' || table_name || ' disable all triggers' || ';' from user_tables;
spool off
set termout on
start trigs_off

set feedback on
set pages 9999
set verify on
set define on

