Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Enbling and Diabling Table Triggert
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