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>
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