| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: why these tables can not be seen from user_segments?
Are those missing tables - IOTs?
If so, you will not see them as table segments, they will show up as index
segments.
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
> Hi:
>
> Oracle 8173 on Sun Box.
>
> SQL> select count(*) from user_tables;
>
> COUNT(*)
> ----------
> 326
>
> SQL> select count(*) from user_segments where segment_type='TABLE';
>
> COUNT(*)
> ----------
> 318
>
> SQL> select segment_name from user_segments
> 2 where segment_type='TABLE'
> 3 and segment_name like 'DR$%'
> 4 order by segment_name;
>
> SEGMENT_NAME
> --------------------------------------------------------------------------
--Received on Tue Feb 04 2003 - 10:39:54 CST
> ----
> DR$ABSTRACT_TEXT$I
> DR$ABSTRACT_TEXT$R
> DR$COREREF_ABSTRACT$I
> DR$COREREF_ABSTRACT$R
> DR$COREREF_TITLE$I
> DR$COREREF_TITLE$R
> DR$TEST_CONTEXT$I
> DR$TEST_CONTEXT$R
>
> 8 rows selected.
>
> 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?
>
> TIA.
>
> Guang Mei
>
> --
> 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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: ineyman_at_perceptron.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).
 |
 |