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], "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] >
