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 -> Database Object References

Database Object References

From: Rick Wiker <notrump_at_comcast.net>
Date: 25 Aug 2004 08:01:13 -0700
Message-ID: <c04ad1a8.0408250701.1df718dc@posting.google.com>


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 Received on Wed Aug 25 2004 - 10:01:13 CDT

Original text of this message

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