 | |
SQL to find the list of objects that reference a table
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: SQL to find the list of objects that reference a table -
08-14-2008
, 11:56 AM
|
On Aug 14, 12:30 pm, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote: 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 Hi all Found the query here http://jenniferlinca.wordpress.com/2...nts-in-oracle/ Thanks Saravanan |
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
#12
| |||
| |||
|
|
On Aug 14, 12:30 pm, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote: 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 Hi all Found the query here http://jenniferlinca.wordpress.com/2...nts-in-oracle/ Thanks Saravanan |
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
#13
| |||
| |||
|
|
On Aug 14, 12:30 pm, Saravanan <vsr.sarava... (AT) gmail (DOT) com> wrote: 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 Hi all Found the query here http://jenniferlinca.wordpress.com/2...nts-in-oracle/ Thanks Saravanan |
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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.