what is obj$.type#=10?

From: Ivan Chow <ichow2_at_hotmail.com>
Date: Tue, 22 Jun 2004 11:20:34 -0400
Message-ID: <BAY12-F64diAG95OIKa00005133@hotmail.com>

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

Received on Tue Jun 22 2004 - 10:17:30 CDT