Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1093498885.322957_at_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
Thank You, perfect!
Received on Thu Aug 26 2004 - 08:33:20 CDT
