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

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Mon, 23 Jun 2003 17:47:47 -0700
Message-ID: <F001.005B81FA.20030623164449@fatcity.com>

Barbara,

Take look into $ORACLE_HOME/rdbms/admin/sql.bsq:

  type#         number not null,                 /* object type (see KQD.H): */
  /* 1 = INDEX, 2 = TABLE, 3 = CLUSTER, 4 = VIEW, 5 = SYNONYM, 6 = SEQUENCE, */
             /* 7 = PROCEDURE, 8 = FUNCTION, 9 = PACKAGE, 10 = NON-EXISTENT, */
              /* 11 = PACKAGE BODY, 12 = TRIGGER, 13 = TYPE, 14 = TYPE BODY, */
      /* 19 = TABLE PARTITION, 20 = INDEX PARTITION, 21 = LOB, 22 = LIBRARY, */
                                             /* 23 = DIRECTORY , 24 = QUEUE, */


    /* 25 = IOT, 26 = REPLICATION OBJECT GROUP, 27 = REPLICATION PROPAGATOR, */

    /* 28 = JAVA SOURCE, 29 = JAVA CLASS, 30 = JAVA RESOURCE, 31 = JAVA JAR, */

                 /* 32 = INDEXTYPE, 33 = OPERATOR , 34 = TABLE SUBPARTITION, */
                                                  /* 35 = INDEX SUBPARTITION */

Richard Ji

-----Original Message-----
From: Barbara Baker [mailto:[EMAIL PROTECTED] Sent: Mon 6/23/2003 7:49 PM

To:     Multiple recipients of list ORACLE-L
Cc:     
Subject:        What are the type#'s in obj$ ?

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)
Thanks!

Barb
BAARF party number 20

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  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).



<<winmail.dat>>

Received on Mon Jun 23 2003 - 19:47:47 CDT