Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: find out tirggers in a DB
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