Re: Enbling and Diabling Table Triggert

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Sun, 04 Jun 2000 09:27:57 -0400
Message-Id: <10518.107663@fatcity.com>

since the body of your message was blank, i'll fill it in and see if thats what you wanted :)

joe

spool disable_triggers.sql
select 'alter trigger '||trigger_name||' disable;' from user_triggers
where table_name = 'YOU FILL IN THIS PART';

spool off
@disable_triggers.sql

Alroy Mascrenghe wrote:
>
>
>
>
> ____________________________________________________________
> Do You Yahoo!?

Joe Testa http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs Received on Sun Jun 04 2000 - 08:27:57 CDT