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).
Received on Mon Jun 23 2003 - 22:06:01 CDT
