Re: find out tirggers in a DB

From: <jasrit_at_gmail.com>
Date: Thu, 07 Jun 2007 13:37:19 -0000
Message-ID: <1181223439.939427.70020@p47g2000hsd.googlegroups.com>

On Jun 7, 3:44 am, klonic <jaume..._at_gmail.com> wrote:
> Hi,
>
> I've a DB not designed by me. I found that there is a trigger updating
> table B when I update table A. I want to disable this trigger but I
> don't know the name. Can someone help me? Thanks.
>
> I thought that I would find this trigger in table user_triggers, but
> there isn't :(
>
> Thanks again!

just run the below query
and give the input on table A and the check B it i'' work Enjoy!

SELECT OWNER,'CREATE OR REPLACE TRIGGER
',TRIGGER_NAME,DESCRIPTION,TRIGGER_BODY,'/' FROM DBA_TRIGGERS
WHERE OWNER = upper('&&owner')
AND TABLE_NAME = upper('&&table');

jaspreet Received on Thu Jun 07 2007 - 08:37:19 CDT