Re: IOT - Tablespace

RK wrote:
> Is there any reason why the tablespace_name in user_tables and
> all_tables is blank (empty) for an Index Organized Table.
>
> It shows up blank for partitioned tables too, but thats because each
> partition can be stored in different tablespaces. I can query
> user_segments with segment_name = <partitioned_table_name> to get the
> tablespace, but not for IOT
>

Hello rajXesh,

AFAIK that is because IOT have all their data in the primary key index. It should appear in user_indexes. If you look at user segments you actually find an index segment but no table segment for your IOT.

Hope that hleps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de