RE: Dependency tree of packages/procedures and functions

  • From: Jesper Haure Norrevang <jhn.aida@xxxxxx>
  • To: GLeonard@xxxxxxxxxxxxx, 'Oracle-L Freelists' <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 11 Jan 2005 09:47:40 +0100

George,

Fortunately Oracle maintains a dependency
list. Thus if you e.g. change a table
definition, Oracle knows which objects
to invalidate.

You can see the list it in DBA_DEPENDENCIES.

DESCRIBE dba_dependencies
 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 NAME                                      NOT NULL VARCHAR2(30)
 TYPE                                               VARCHAR2(17)
 REFERENCED_OWNER                                   VARCHAR2(30)
 REFERENCED_NAME                                    VARCHAR2(64)
 REFERENCED_TYPE                                    VARCHAR2(17)
 REFERENCED_LINK_NAME                               VARCHAR2(128)
 DEPENDENCY_TYPE                                    VARCHAR2(4)

Hope this helps.

Regards
Jesper Haure Norrevang

-----Oprindelig meddelelse-----
Fra: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] P=E5
vegne af Leonard, George
Sendt: 11. januar 2005 09:35
Til: Oracle-L Freelists
Emne: Dependency tree of packages/procedures and functions


Hi all

Hope you can help.

As with all big projects our developers forgot to listen to us when we
asked them to keep a dependency tree what calls what.

Now we are busy going into pre-prod etc and get asked to move Package A,
doing this nicely goes and breaks half the world down the line,

I would like to run something against the database (packages, procedures
and functions) to generate a dependency list.

Any ideas what is out there that can do this (freeware prepared), any
output acceptable.

George
=3D20________________________________________________
George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard@xxxxxxxxxxxxx
=3D20
You Have The Obligation to Inform One Honestly of the risk, And As a
Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=3D20

_________________________________________________________________________=
=3D
__________________________


The views expressed in this email are, unless otherwise stated, those of =
=3D
the author and not those
of the FirstRand Banking Group an Authorised Financial Service Provider =
o=3D
r its management.
The information in this e-mail is confidential and is intended solely =
for=3D
=3D20the addressee.
Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, =
distribut=3D
ion or any action taken or=3D20
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and =
integrit=3D
y of information and data=3D20
transmitted electronically and to preserve the confidentiality thereof, =
n=3D
o liability or=3D20
responsibility whatsoever is accepted if information or data is, for =
what=3D
ever reason, corrupted=3D20
or does not reach its intended destination.

=3D20                              ________________________________
--
//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l

Other related posts: