Re: Thanks!! What are the type#'s in obj$ ?

From: Manoj Kumar Jha <jmanoj_at_delhi.tcs.co.in>
Date: Mon, 23 Jun 2003 22:20:47 -0700
Message-ID: <F001.005B837F.20030623214449@fatcity.com>

obj$.type#=10 --NON-EXISTENT

 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

57 = SECURITY PROFILE

Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 9:09 AM

> Wow. Terrific information.
> Thanks Tanel, Jacques, Richard, and Jared!!!
>
> The database and I are having a bit of a disagreement
> about whether this object really exists.
>
> I guess the database wins.
>
> Thanks again.
>
> Barb
>
>
> --- Tanel Poder <[EMAIL PROTECTED]> wrote:
> > Hi!
> >
> > Check
> > http://www.jlcomp.demon.co.uk/faq/non_exist.html for
> > explanation.
> >
> > Also, I'll include a little sample, how they might
> > occur.
> >
> >
> > Cheers,
> > Tanel.
> >
> > SQL> create table a (b number);
> >
> > Table created.
> >
> > SQL> create synonym s for a;
> >
> > Synonym created.
> >
> > SQL> select name, type# from obj$ where name = 'A';
> >
> > NAME TYPE#
> > ------------------------------ ----------
> > A 2
> > A 2
> >
> > SQL> select name, type# from obj$ where name = 'S';
> >
> > NAME TYPE#
> > ------------------------------ ----------
> > S 5
> >
> > SQL> drop synonym s;
> >
> > Synonym dropped.
> >
> > SQL> select name, type# from obj$ where name = 'S';
> >
> > NAME TYPE#
> > ------------------------------ ----------
> > S 10
> >
> > SQL> startup force
> > ORACLE instance started.
> >
> > Total System Global Area 135338868 bytes
> > Fixed Size 453492 bytes
> > Variable Size 109051904 bytes
> > Database Buffers 25165824 bytes
> > Redo Buffers 667648 bytes
> > Database mounted.
> > Database opened.
> > SQL> select name, type# from obj$ where name = 'S';
> >
> > no rows selected
> >
> > SQL>
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Tuesday, June 24, 2003 2:49 AM
> >
> >
> > >
> > > 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).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Tanel Poder
> > 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).
>
>
> __________________________________
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Manoj Kumar Jha
  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 Tue Jun 24 2003 - 00:20:47 CDT