Table with data but not segment

From: <Joel.Patterson@xxxxxxxxxxx>
To: <Oracle-L@xxxxxxxxxxxxx>
Date: Fri, 30 Jan 2009 10:36:07 -0500

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

Follow-Ups:

Re: Table with data but not segment
From: Robert Freeman

References:
- RE: rman duplicate to previous version after upgrade
  - From: Toth, Istvan 5 (GE Money)

Table with data but not segment

Other related posts: