Home » SQL & PL/SQL » SQL & PL/SQL » Forward dependencies of a Database object
Forward dependencies of a Database object [message #442857] Thu, 11 February 2010 00:39 Go to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member

Hi,

I need to find the forward dependencies of a database object in oracle.

Example: PKG1

I need to know what all other DB objects using the package PKG1 and their dependencies in entire Database.

Will public_dependency pulls all the depndencies from entire database or at schema level?

I queried public dependency and found some results. how to verify the result.

What's the difference between dba_dependencies, public_dependency, ideptree.

Any help really appreciated.

thanks in advance
Re: Forward dependencies of a Database object [message #442860 is a reply to message #442857] Thu, 11 February 2010 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I need to find the forward dependencies of a database object in oracle.

http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1236
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1237

Quote:
What's the difference between dba_dependencies, public_dependency, ideptree

Database Reference contains the definition of the views.
You can also query DBA_VIEWS to know the text of each view.
By the way, "ideptree" does not exist on my databases.

Regards
Michel

[Updated on: Thu, 11 February 2010 00:45]

Report message to a moderator

Re: Forward dependencies of a Database object [message #442875 is a reply to message #442860] Thu, 11 February 2010 02:03 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.orafaq.com/forum/mv/msg/153487/436773/136607/#msg_436773

Translated page

For The functionality difference
http://www.consultingservicesprovider.com/dbatool/docs/DataDictionary.pdf


Quote:
DBA_DEPENDENCIES
Lists dependencies between database objects. Used to determine which objects become invalid after other objects are altered
or dropped.

PUBLIC_DEPENDENCY
Lists dependencies using only object numbers.
utldtree.sql
Shows objects recursively dependent on given object.


Hope this is enough...

sriram
Previous Topic: Semi Join Issue
Next Topic: Time difference
Goto Forum:
  


Current Time: Mon Sep 26 06:02:30 CDT 2016

Total time taken to generate the page: 0.13561 seconds