SQL to list tablespaces for partitioned index only table?
For normal tables I use the following sql:
select table_name, partition_name, tablespace_name
from user_tab_partitions
However this does not work for Index Only Tables. Reviewing the details of user_tab_partitions, it expressly returns null for the tablespace_name for IOTs.
Can anyone suggest how I might get a list of partitions and tablespaces for my index only tables?
I am using Oracle 9i on Solaris.
Thanks
Paul Graves