Re: what is obj$.type#=10?
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 09:01:10 +0100
Note in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st
----- Original Message -----
From: "Powell, Mark D" <mark.powell@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, June 22, 2004 4:56 PM
Subject: RE: what is obj$.type#=10?
Ivan, I am just guessing, but the term non-existent is usually associated
with an existence dependency. I only checked a few out of 400 but on my
main system every type 10 that I checked appeared to be an object that is
referenced in stored code.
-- I agree. Specifically, you get lots of these when
-- you create a permanent object that depends on
-- public synonym. At some point, you may create
-- a local object that "conceals" the public synonym,
-- at which point the thing that depends on the synonym
-- has to become invalid and depend on the local object.
-- To allow this to happen, you NEED a 'non-existent'
-- object of the same name to exist, so that the permanent
-- object can depend on its non-existence, and notice when
-- it ceases to be non-existent.
The object you are interested in has the word "queue" in its name. Is there
any change that Advanced Queuing is or was in use on your system? If so
then perhaps the answer on how to remove the objects is through the queue
management packages.
HTH -- Mark D Powell --
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
