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

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Mon, 23 Jun 2003 18:16:31 -0700
Message-ID: <F001.005B824C.20030623175418@fatcity.com>

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

Received on Mon Jun 23 2003 - 20:16:31 CDT