Home » SQL & PL/SQL » SQL & PL/SQL » Need help on ALL/DBA_DEPENDENCIES
Need help on ALL/DBA_DEPENDENCIES [message #236618] Thu, 10 May 2007 07:16 Go to next message
gkodakalla
Messages: 49
Registered: March 2005
Member
Hi,
while checking some dependencies about some packages, we found the following
in DBA_DEPENDENCIES.

1) REFERENCED_TYPE is shown as NON-EXISTENT.
2) DEPENDENCY_TYPE is 'HARD'

we switch synonyms every day after the table loading. These packages use some of those tables in package body, but not in the specification.

Can any one explain what does the above two meant by?


Note: I made same post at
http://forums.oracle.com/forums/thread.jspa?threadID=506180&tstart=0
and already read oracle doc
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_1041.htm#i1576452

Thanks
Giridhar Kodakalla
Re: Need help on ALL/DBA_DEPENDENCIES [message #236795 is a reply to message #236618] Fri, 11 May 2007 01:00 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Looking at the DBA_DEPENDENCIES - HARD means it's not a REF and NON-EXISTENT means it is of type 10:

select u.name, o.name,
decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
8, 'FUNCTION', 9, 'PACKAGE', 10, 'NON-EXISTENT',
11, 'PACKAGE BODY', 12, 'TRIGGER',
13, 'TYPE', 14, 'TYPE BODY',
28, 'JAVA SOURCE', 29, 'JAVA CLASS', 56, 'JAVA DATA',
'UNDEFINED'),
decode(po.linkname, null, pu.name, po.remoteowner), po.name,
decode(po.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
8, 'FUNCTION', 9, 'PACKAGE', 10, 'NON-EXISTENT',
11, 'PACKAGE BODY', 12, 'TRIGGER',
13, 'TYPE', 14, 'TYPE BODY',
28, 'JAVA SOURCE', 29, 'JAVA CLASS', 56, 'JAVA DATA',
'UNDEFINED'),
po.linkname,
decode(d.property, 2, 'REF', 'HARD')
from sys.obj$ o, sys.disk_and_fixed_objects po, sys.dependency$ d, sys.user$ u,
sys.user$ pu
where o.obj# = d.d_obj#
and o.owner# = u.user#
and po.obj# = d.p_obj#
and po.owner# = pu.user#

Previous Topic: pl/sql tuning
Next Topic: ERROR: ORA-01017
Goto Forum:
  


Current Time: Mon Dec 05 21:23:21 CST 2016

Total time taken to generate the page: 0.10097 seconds