Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Non-Existent Objects...Explain Please

Non-Existent Objects...Explain Please

From: Judie Stroup <judie.stroup_at_lmco.com>
Date: 1997/04/24
Message-ID: <335F6EDB.161@lmco.com>#1/1

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

judie.stroup_at_lmco.com Received on Thu Apr 24 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US