Table with data but not segment

From: <Joel.Patterson_at_crowley.com>
Date: Fri, 30 Jan 2009 10:36:07 -0500
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA02440E43_at_JAXMSG01.crowley.com>


I would like to clarify or confirm. I can query (user_tables union user_indexes) minus user_segments and see about 4 tables and 9 indexes. 7 turn out to be normal and 2 are IOT - TOP indexes.

I guess the 3 tables with 0 rows and all the indexes that go with them might not have a segment?

There is one table with and IOT - TOP index with 100000 rows. Two indexes go with this table, one of them is IOT - TOP, the other normal.

Even and Index has a segment, why would I not have a segment for this(ese) table(s) or Indexes?

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 30 2009 - 09:36:07 CST

Original text of this message