-- This script will create a SQL script to remove any tables triggers in the current schema.
-- Mark Reineck 12-22-1997

set feedback off
set head off
set echo off

-- Write the script to a file, otherwise it is useless

spool deltbls.sql

-- Create the trigger disable sql statements

select 'alter table ' || table_name || ' disable all triggers;' from user_tables ;

spool off;

-- Reset some stuff

set feedback on
set head on
set echo on