RE: Sopa9m: Finding triggers/procedures names populating a table

RE: Sopa9m: Finding triggers/procedures names populating a table

 

  

Try dba_dependencies or all_dependencies


-----Original Message-----
From: Deepak Panda
[mailto:oracledba-ezmlmshield-x1460693.[Email address protected]
Sent: Friday, January 28, 2005 6:38 AM
To: LazyDBA Discussion
Subject: Re: Sopa9m: Finding triggers/procedures names populating a
table


I hope dba_triggers will help you in finding the triggers. But it is hard to
find the procedures which are populating the tables.

Regards

Deepak
----- Original Message -----
From: "Parul Patel "
<oracledba-ezmlmshield-x80410198.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, January 28, 2005 4:52 PM
Subject: Sopa9m: Finding triggers/procedures names populating a table


> Hi
> I have a table in which data is getting populated from many triggers and
> procedures .How can i find out the names of the triggers and procedures
> which are populating that table .
> Any v$view exists that contains such information ?
>
> TIA
> Parul
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


==============================================================================
This message is for the sole use of the intended recipient. If you received
this message in error please delete it and notify us. If this message was
misdirected, CSFB does not waive any confidentiality or privilege. CSFB
retains and monitors electronic communications sent through its network.
Instructions transmitted over this system are not binding on CSFB until they
are confirmed by us. Message transmission is not guaranteed to be secure.
==============================================================================


Oracle LazyDBA home page