Hi all
I want to find all the objects that reference a given table. Can
anyone please provide the SQL query to do the same?

Thanks
Saravanan

On Aug 14, 12:30*pm, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Hi all
Found the query here
http://jenniferlinca.wordpress.com/2...nts-in-oracle/

Thanks
Saravanan

On Aug 14, 12:30*pm, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Hi all
Found the query here
http://jenniferlinca.wordpress.com/2...nts-in-oracle/

Thanks
Saravanan

On Aug 14, 12:30*pm, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Hi all
Found the query here
http://jenniferlinca.wordpress.com/2...nts-in-oracle/

Thanks
Saravanan

On Aug 14, 12:30*pm, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Hi all
Found the query here
http://jenniferlinca.wordpress.com/2...nts-in-oracle/

Thanks
Saravanan

On 14 Aug, 08:30, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Check out the DBA_DEPENDENCIES view.

HTH

-g

On 14 Aug, 08:30, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Check out the DBA_DEPENDENCIES view.

HTH

-g

On 14 Aug, 08:30, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Check out the DBA_DEPENDENCIES view.

HTH

-g

On 14 Aug, 08:30, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote:
Check out the DBA_DEPENDENCIES view.

HTH

-g

Saravanan wrote:
That would be fine but it would also be incorrect with respect to the
question you asked. You said "objects" and that includes views and
procedures, etc.

Gazzag has pointed you to dba_dependencies which gives it to you at
the first level.

If you want the entire story then go to Morgan's Library at
www.psoug.org and look up the DBMS_UTILITY built-in package.
It contains a GET_DEPENDENCY procedure that is far more robust.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org