Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Finding Dependencies
In article <Beso8.23741$uR5.51839_at_newsfeeds.bigpond.com>, "Peta says...
>
>Hi
>
>I am trying to find dependencies for tables through Visual basic
>and was wondering if there are any tables used in oracle to store the
>dependencies for objects in a schema eg (triggers ,Indexes,sequences)
>
>I can see that toad will pickup these dependencies but I cannot find
>reference to where they are stored.
>
>Thanks
>
>Paul Grimaldi
>
>
USER_DEPENDENCIES
ALL_DEPENDENCIES
DBA_DEPENDENCIES
has that information.
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Wed Mar 27 2002 - 18:37:07 CST