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

Home -> Community -> Mailing Lists -> Oracle-L -> AW: obj$ table -- type column

AW: obj$ table -- type column

From: Jentzig Sven <sven.jentzig_at_cellway.de>
Date: Wed, 21 Feb 2001 02:58:28 -0800
Message-ID: <F001.002B954D.20010221015545@fatcity.com>

Can anyone say, what Objects with "type = 10" are? In DBA_OBJECTS-View it's called NON_EXISTEND, but there are a few objects of this type.

> ----------
> Von: Jacques Kilchoer[SMTP:Jacques.Kilchoer_at_quest.com]
> Antwort an: ORACLE-L_at_fatcity.com
> Gesendet: Dienstag, 20. Februar 2001 21:20
> An: Multiple recipients of list ORACLE-L
> Betreff: RE: obj$ table -- type column
>
> > -----Original Message-----
> > From: Pablo ksksksk [ mailto:p_rodri99_at_yahoo.es]
> > Sent: mardi, 20. février 2001 11:50
> >
> > what does represent the column "type=11" and "type=0"
> > from obj$ table?
>
>
> Look at the dba_objects view (see below).
> type = 11 is package body
>
> type = 0 is 'next object'? In my 8.1.6 test database I only see one object
> with type 0, and the object name is '_NEXT_OBJECT'. Don't know what that
> is.
>
> SQL> set long 4000
> SQL> select text from dba_views where view_name = 'DBA_OBJECTS' ;
>
> TEXT
> --------------------------------------------------------------------------
> -----
> select u.name, o.name, o.subname, o.obj#, o.dataobj#,
> decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3,
> 'CLUSTER',
> 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE',
> 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
> 11, 'PACKAGE BODY', 12, 'TRIGGER',
> 13, 'TYPE', 14, 'TYPE BODY',
> 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21,
> 'LOB',
> 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE',
> 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA
> RESOURCE',
> 32, 'INDEXTYPE', 33, 'OPERATOR',
> 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION',
> 39, 'LOB PARTITION', 40, 'LOB SUBPARTITION',
> 43, 'DIMENSION',
> 44, 'CONTEXT', 47, 'RESOURCE PLAN',
> 48, 'CONSUMER GROUP',
> 51, 'SUBSCRIPTION', 52, 'LOCATION', 56, 'JAVA DATA',
>
> 'UNDEFINED'),
> o.ctime, o.mtime,
> to_char(o.stime, 'YYYY-MM-DD:HH24:MI:SS'),
> 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))))
> and o.name != '_NEXT_OBJECT'
> and o.name != '_default_auditing_options_'
> union all
> select u.name, l.name, NULL, to_number(null), to_number(null),
> 'DATABASE LINK',
> l.ctime, to_date(null), NULL, 'VALID','N','N', 'N'
> from sys.link$ l, sys.user$ u
> where l.owner# = u.user#
>
> ------
> any ignorant comments made are the sole responsibility of J. R. Kilchoer
> and should not reflect adversely upon my employer.
>
>
> Jacques R. Kilchoer
> (949) 754-8816
> Quest Software, Inc.
> 8001 Irvine Center Drive
> Irvine, California 92618
> U.S.A.
> http://www.quest.com
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jentzig Sven
  INET: sven.jentzig_at_cellway.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Feb 21 2001 - 04:58:28 CST

Original text of this message

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