Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Script for disable / enable Triggers
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
![]() |
![]() |