Index on which tablespace Index on which tablespace database database

Index on which tablespace


The information is in the ALL_INDEXES (or USER_INDEXES) view:

select tablespace_namefrom all_indexeswhere owner = 'MYSCHEMA'and index_name = 'MYINDEX';


user_indexes.tablespace_name is null for partitioned indices.

Viewing Information About Partitioned Tables and Indexes suggests that user_ind_partitions view can be used to check containing tablespace for each separate index partition:

select index_name, partition_name, tablespace_name from user_ind_partitions    where index_name = 'MYINDEX';