Re: Non-Existent Objects...Explain Please

On Thu, 24 Apr 1997 07:31:55 -0700, Judie Stroup <judie.stroup_at_lmco.com> wrote:

>In my database I stumbled across what Oracle refers to in its
>Data Dictionary views as "non-existent" objects. They show up
>in the OBJ$ table as TYPE 10. I first saw them referenced in
>the USER_DEPENDENCIES view. I had a procedure which referenced
>a package in the same schema. When I moved the package to a
>different schema an recompiled the procedure, the USER_DEPENDENCIES
>view says my procedure references the package in the new schema
>AS WELL AS the now "non-existent" package in the old schema.
>
>What's going on here? Can anyone explain? Thanks in advance...

The procedure is now dependent on the "non existence" of a package of that name in its own schema. It such a package were to be created, it would invalidate the procedure and cause it to be recompiled. To track this dependency, Oracle creates a row in OBJ$ as part of the parsing of the procedure. Interestingly, if parsing of the dependent object fails for any reason, Oracle does not clean up the non-existent objects in OBJ$ - they remain as litter.

Warning: I am going from memory here. I have not checked this lately. Received on Sun Apr 27 1997 - 00:00:00 CDT