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