Re: Q: odd entries in user_dependencies

Andy Hassall (andy_at_andyh.co.uk) wrote:
: 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.

I would never have thought of that, but it makes a lot of sense now I hear it. Thanks greatly. Received on Mon Jun 19 2006 - 19:29:47 CDT