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>>