also it is use for negative dependancy tracking......by Oracle
internally....
- Original Message -----
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 24, 2003 10:08 AM
>
> 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 -----
> From: "Barbara Baker" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, June 24, 2003 9:09 AM
> Subject: Thanks!! What are the type#'s in obj$ ?
>
>
> > 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:12:48 CDT
