Search code examples
databaseoracle-databasejdbcindexingtablespace

Index on which tablespace

How to find out which 'tablespace' a particular 'index' belongs to. (oracle) (need to use it via jdbc)

Solution

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

    select tablespace_name
from all_indexes
where owner = 'MYSCHEMA'
and index_name = 'MYINDEX';