RE: what is obj$.type#=10?

From: Powell, Mark D <mark.powell_at_EDS.COM>
Date: Tue, 22 Jun 2004 11:56:51 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0ABA5@usahm018.exmi01.exch.eds.com>

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.

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ivan Chow Sent: Tuesday, June 22, 2004 11:21 AM
To: oracle-l_at_freelists.org
Subject: what is obj$.type#=10?

hi,
does anyone know what type#=10 refers to?

SQL> select u.name,o.name, o.type# from obj$ o, user$ u where o.name='MRP_QUEUE' and u.user#=o.owner# and o.type#=10;

NAME                           NAME                                TYPE#
------------------------------ ------------------------------ ----------
PUBLIC                         MRP_QUEUE                              10
APPSD                          MRP_QUEUE                              10

I queried dba_objects but the object was not listed. SQL> select * from dba_objects where object_name='MRP_QUEUE';

no rows selected

The source text for dba_objects explicitly filtered out objects where type#=10.

...
...
...

       decode(o.status, 0, 'N/A', 1, 'VALID', 'INVALID'),
       decode(bitand(o.flags, 2), 0, 'N', 2, 'Y', 'N'),
       decode(bitand(o.flags, 4), 0, 'N', 4, 'Y', 'N'),
       decode(bitand(o.flags, 16), 0, 'N', 16, 'Y', 'N')

from sys.obj$ o, sys.user$ u
where o.owner# = u.user#
and o.linkname is null
and (o.type# not in (1 /* INDEX - handled below */,

                      10 /* NON-EXISTENT */)
       or
       (o.type# = 1 and 1 = (select 1
                              from sys.ind$ i
                             where i.obj# = o.obj#
                               and i.type# in (1, 2, 3, 4, 6, 7, 9))))


       ...

       ...

       ...

Any idea what type#=10 is and how I can remove the object- MRP_QUEUE?

Thanks.

Ivan

Is your PC infected? Get a FREE online computer virus scan from McAfee(r) Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 22 2004 - 10:54:03 CDT