Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Script for disable / enable Triggers

Re: Script for disable / enable Triggers

From: Bob <pruder_at_gatorbait.com>
Date: 1997/08/21
Message-ID: <01bcae5b$22cc42c0$100000be@fs>#1/1

spool <yourfile>
select 'alter table '||table_name|| ' disable all triggers;' from tab; spool off

Dieter Soergel <dscs.de_at_t-online.de> wrote in article <5tci6e$gln$1_at_news01.btx.dtag.de>...
> Hello,
> has anybody a Script which helps to disable / enable all defined
> Triggers?
>
Received on Thu Aug 21 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US