Q: odd entries in user_dependencies

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".

The UTILITY_PKG package and body compiles fine, and is in use by the application. I would expect the above to at least disappear after the package is recompiled but that doesn't clean them out.

Anyway, if anyone could shed light on these odd entires I would appreciate it.

Thanks. Received on Mon Jun 19 2006 - 16:33:08 CDT