Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Object Dependencies

Subhadeep RoyJun 11 2012 — edited Jun 12 2012

Hi Friends,

I need to create a report in which I will get a Dependency tree of db objects in a schema. For an example Suppose A is a synonym. A is called by B & C. Further B is called by XYZ and C is called by PQR. So Can we create a dependency report like the below one.

A B XYZ
C PQR

Can Anybody help me out in this case?

Thanks in advance!

Cheers!!

Roy

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2012

Added on Jun 11 2012

#11g, #database, #dba, #general-database-discussions, #oracle, #plsql, #sql

8 comments

1,207 views