SELECT * FROM ALL_INDEXES WHERE TABLESPACE_NAME = 'MY_TABLESPACE_NAME';
SELECT * FROM ALL_INDEXES WHERE TABLESPACE_NAME = 'MY_TABLESPACE_NAME';SELECT * from all_ind_columns x where exists (select 'x' from all_indexes where owner = x.index_owner and index_name = x.index_name and TABLESPACE_NAME = 'MY_TABLESPACE_NAME');
FROM ALL_INDEXES
WHERE TABLESPACE_NAME = 'MY_TABLESPACE_NAME';
FROM ALL_INDEXES
WHERE TABLESPACE_NAME = 'MY_TABLESPACE_NAME';SELECT *
from all_ind_columns x
where exists (select 'x' from all_indexes
where owner = x.index_owner
and index_name = x.index_name
and TABLESPACE_NAME = 'MY_TABLESPACE_NAME');