Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> IOT - Tablespace
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
Thanks