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

The example given below is tootaly wrong in this concern. Type 10 is used for nagetivec dependancy tracking of objects. This is use in reference of public on object of one schema and used by other schema and oracle internally assume that second schema have the referenced object and have type#10 ( in reality it is not exist).

• 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).