Trying to find the specific tablespace names that were created for indexes only. I don't want to see the tablespaces names that are already used for tables.
Something like below, but i couldn't have it working due to syntax error. Can someone fix it?
select tablespace_name from dba_indexes where tablespace_name not EXISTS (select distinct tablespace_name from dba_tables where owner like 'USER') and owner like 'USER'