Oracle-L: Re: why these tables can not be seen from user

From: <JApplewhite_at_austin.isd.tenet.edu>
Date: Tue, 04 Feb 2003 10:44:42 -0800
Message-ID: <F001.005438B7.20030204104442@fatcity.com>

Guang Mei,

All the DR$ objects are interMedia Index segments - some are tables, some are indexes, some are IOTs. Check out OTN and/or MetaLink for docs on how each segment type contributes to the interMedia indexing process. It's quite interesting.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
JApplewhite_at_austin.isd.tenet.edu

                                                                                                           
                      "gmei"                                                                               
                      <gmei_at_incyte.com>        To:       Multiple recipients of list ORACLE-L              
                      Sent by:                  <ORACLE-L_at_fatcity.com>                                     
                      root_at_fatcity.com         cc:                                                         
                                               Subject:  why these tables can not be seen from             
                                                user_segments?                                             
                      02/04/2003 09:24                                                                     
                      AM                                                                                   
                      Please respond to                                                                    
                      ORACLE-L

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

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

Author: gmei
INET: gmei_at_incyte.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: JApplewhite_at_austin.isd.tenet.edu

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). Received on Tue Feb 04 2003 - 12:44:42 CST

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