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 -> Re: Q: odd entries in user_dependencies

Re: Q: odd entries in user_dependencies

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 20 Jun 2006 00:09:13 +0100
Message-ID: <d9be929o3ur2g6nor9k9pqtvfnvd4jd285@4ax.com>


On 19 Jun 2006 13:33:08 -0800, yf110_at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:

>Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
>
>I'm looking at USER_DEPENDENCIES and I see some odd entries. There are
>lots of these entries, I copied just a few to show.
>
>NAME TYPE REFERENCED REFERENCED_NAME REFERENCED_TYPE
> _OWNER
>------------ ------------- ---------- ------------------ ----------------
>
>UTILITY_PKG PACKAGE BODY DGEN DBMS_OUTPUT NON-EXISTENT
>UTILITY_PKG PACKAGE BODY DGEN USER_TAB_COLUMNS NON-EXISTENT
>
>UTILITY_PKG PACKAGE BODY DGEN USER_CONS_COLUMNS NON-EXISTENT
>UTILITY_PKG PACKAGE BODY DGEN USER_CONSTRAINTS NON-EXISTENT
>
>
>Obviously I don't expect anyone to know exactly what someone did on my
>system to get these entries, but I would like to understand in the general
>sense "what's up".

 NON-EXISTENT type indicates a "negative dependency", which generally shows up when an object depends on a another object via a public synonym.

 If the referenced object is being resolved via a public synonym, then that requires that there is no object (or private synonym) in the local naming scope of the same name, because these take precedence over public synonyms - so Oracle registers a dependency on the named object being non-existent in the local schema.

 e.g. if you created an object named DBMS_OUTPUT in the DGEN schema, then UTILITY_PKG would become invalid.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Received on Mon Jun 19 2006 - 18:09:13 CDT

Original text of this message

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