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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 <[EMAIL PROTECTED]> > 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: [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: gmei 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).
