what is obj$.type#=10?
- From: "Ivan Chow" <ichow2@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 22 Jun 2004 11:20:34 -0400
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@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:
