RE: why these tables can not be seen from user_segments?

No matter where I look, there is no segment correspnding to it. Anyway, here is the user_table info (not sure if it helps).

SQL> select TABLE_NAME,IOT_TYPE
  2 from user_tables where table_name='DR$ABSTRACT_TEXT$K';

TABLE_NAME                     IOT_TYPE
------------------------------ ------------
DR$ABSTRACT_TEXT$K             IOT

SQL> select * from dba_segments where segment_name ='DR$ABSTRACT_TEXT$K';

no rows selected

SQL>
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jonathan
> Lewis
> Sent: Tuesday, February 04, 2003 12:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: why these tables can not be seen from user_segments?
>
>
>
> I think you will find that these tables
> are index-organized-tables. The table
> definition exists, but in the absence of
> an overflow, there is only an index
> segment.
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> ____UK_______March 19th
> ____USA_(FL)_May 2nd
>
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> -----Original Message-----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: 04 February 2003 16:17
>
>
> >Hi:
> >
> >Oracle 8173 on Sun Box.
> >
> >
> >SQL> select table_name from user_tables
> > 2 where table_name like 'DR$%'
> > 3 order by table_name;
> >
> >TABLE_NAME
> >------------------------------
> >DR$ABSTRACT_TEXT$I
> >DR$ABSTRACT_TEXT$K
> >DR$ABSTRACT_TEXT$N
> >DR$ABSTRACT_TEXT$R
> >DR$COREREF_ABSTRACT$I
> >DR$COREREF_ABSTRACT$K
> >DR$COREREF_ABSTRACT$N
> >DR$COREREF_ABSTRACT$R
> >DR$COREREF_TITLE$I
> >DR$COREREF_TITLE$K
> >DR$COREREF_TITLE$N
> >
> >TABLE_NAME
> >------------------------------
> >DR$COREREF_TITLE$R
> >DR$TEST_CONTEXT$I
> >DR$TEST_CONTEXT$K
> >DR$TEST_CONTEXT$N
> >DR$TEST_CONTEXT$R
> >
> >16 rows selected.
> >
> >Why tables like DR$ABSTRACT_TEXT$K, DR$ABSTRACT_TEXT$N do not have
> their
> >corresponding segments? What are they and their functions?
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
> 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: ListGuru_at_fatcity.com (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: gmei
  INET: gmei_at_incyte.com

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: ListGuru_at_fatcity.com (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).