Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Object References

Re: Database Object References

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 25 Aug 2004 22:40:33 -0700
Message-ID: <1093498885.322957@yasure>


Rick Wiker wrote:

> I'd like to create a report that lists all DB objects, everything the
> object references and everything it's referenced by.
>
> For Example
>
> Object
> Tablename
> MyTableConstraint ConstrainedByTableName
>
> MyView
> ViewTableName1
> ViewTableName2
>
> MyPackage
> TableReferenced
> FunctionReferenced
> ViewReferenced
>
> I was trying to find what I needed in the system (All...) views, but
> have been unsuccessful.
>
> Thanks

and I'd like to refer you to: dba_dependencies

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Aug 26 2004 - 00:40:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US