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".
>
> 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.
TTBOMK ... there was a dependency and it is no longer valid.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jun 19 2006 - 17:00:39 CDT
