Jangan lupa tambahin where clausenya bila tidak, semua trigger akan dihapus loh. Jadi bukan per user lagi tetapi trigger dari semua user. :)
On 11/27/07, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > SQL> conn / as sysdba > > SQL> SPOOL droptrg.sql > > SQL> SELECT 'DROP TRIGGER ' || owner || '.' || trigger_name || ';' > FROM dba_triggers; > > SQL> SPOOL OFF > SQL> @droptrg.sql > > Be carefull !!! > > --- In [email protected] <indo-oracle%40yahoogroups.com>, > "Nicholasfa AR" <[EMAIL PROTECTED]> > wrote: > > > > Rekan-rekan > > > > Bagaimana membuat script untuk men-drop trigger per user? > > Thx atas bantuannya > > > > > > Rgds > > NC > > > > > > [Non-text portions of this message have been removed] > > > > > [Non-text portions of this message have been removed]
