Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: find out tirggers in a DB

Re: find out tirggers in a DB

From: <jasrit_at_gmail.com>
Date: Thu, 07 Jun 2007 13:39:20 -0000
Message-ID: <1181223560.367077.95490@p77g2000hsh.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!

SELECT OWNER,'CREATE OR REPLACE TRIGGER
',TRIGGER_NAME,DESCRIPTION,TRIGGER_BODY,'/' FROM DBA_TRIGGERS
WHERE OWNER = upper('&&owner')
AND TABLE_NAME = upper('&&table'); Received on Thu Jun 07 2007 - 08:39:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US