Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q: odd entries in user_dependencies
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 toolReceived on Mon Jun 19 2006 - 18:09:13 CDT