Re: find out tirggers in a DB

Thanks to everybody for your help! With your posts and some imagination i solved out the problem!

C U!

On Jun 7, 3:39 pm, "jas..._at_gmail.com" <jas..._at_gmail.com> wrote:
> 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 - 10:22:58 CDT