| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: obj$ table -- type column
Excellent Steve!! Nice demo.
Thankyou
Raghu.
>From: "Steve Adams" <steve.adams_at_ixora.com.au>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: obj$ table -- type column
>Date: Wed, 21 Feb 2001 03:45:23 -0800
>
>Hi Sven,
>
>If an object depends on another object that does not exist, then Oracle
>sometimes needs to representing that non-existent object in OBJ$ for
>dependency
>management reasons. Here is an example ...
>
> SQL> create table t as select * from dual;
>
> Table created.
>
> SQL> create view v as select * from t;
>
> View created.
>
> SQL> drop table t;
>
> Table dropped.
>
> SQL> select * from v;
> select * from v
> *
> ERROR at line 1:
> ORA-04063: view "TEST.V" has errors
>
> SQL> select distinct name, type# from sys.obj$ where name like '_';
>
> NAME TYPE#
> ------------------------------ ----------
> V 4
> T 10
>
> SQL>
>
>@ Regards,
>@ Steve Adams
>@ http://www.ixora.com.au/
>@ http://www.christianity.net.au/
>
>
>-----Original Message-----
>Sent: Wednesday, 21 February 2001 19:56
>To: Multiple recipients of list ORACLE-L
>
>
>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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: raghukota_at_hotmail.com 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 - 21:31:37 CST
 |
 |