Re: Recompile triggers

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 02 Oct 2002 15:07:29 GMT
Message-ID: <3D9B0B9A.494FAAEE_at_exesolutions.com>


Gawie Malherbe wrote:

> Hi All,
>
> I need an effective way to recompile ALL my triggers in a Oracle 8 DB. Can
> one use a script (without knowing the names of all the triggers)?
>
> G

Yes and it will need to look something like this:

DECLARE A cursor that retrieves the names of all triggers where status is invalid

BEGIN
   OPEN CURSOR
   LOOP
      Concatenate to gether a string with the trigger name and the ALTER TRIGGER statement

      Execute Immediate <concatenated string>    END LOOP
END;
/

Daniel Morgan Received on Wed Oct 02 2002 - 17:07:29 CEST

Original text of this message