RE: What are the type#'s in obj$ ?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 23 Jun 2003 17:29:54 -0700
Message-ID: <F001.005B81E0.20030623164448@fatcity.com>

P.S. The description for the type# field in dba_objects is not in the fine manual but you can see it by doing a
select text from dba_views where view_name = 'DBA_OBJECTS' ;

In general to find out information about the columns in a SYS table look at the source code for the corresponding DBA_VIEW, e.g.

OBJ$ -> DBA_OBJECTS
TAB$ -> DBA_TABLES
IND$ -> DBA_INDEXES

etc.

> -----Original Message-----
> From: Jacques Kilchoer
>
> > -----Original Message-----
> > From: Barbara Baker [mailto:[EMAIL PROTECTED]
> >
> > Can anyone tell me in which fine manual I find what
> > the types equate to in obj$
> >
> > I want to know what a type 10 object is:
> >
> > select obj#,name,type# from obj$ where obj#=288484;
> >
> > OBJ# NAME TYPE#
> > ---------- -------------- ----------
> > 288484 V$TEMPFILE 10
> >
> > (Solaris 2.6; Oracle 8.1.7.4)
>
> The source code for dba_objects has a comment in the where
> clause describing type# 10 as 'non-existent'.
> I've seen objects with that type# be created when you drop a synonym.
> e.g.
> SQL> create synonym x for y ;
> Synonyme créé.
>
> SQL> drop synonym x ;
> Synonyme supprimé.
>
> SQL> select name, type# from sys.obj$
> 2 where owner# = sys_context ('userenv', 'current_schemaid')
> 3 and name = 'X' ;
> NAME TYPE#
> ------------------------------ ---------
> X 10
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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 Mon Jun 23 2003 - 19:29:54 CDT