Move items indexes in tablespaces to different tablespace.

Move items indexes in tablespaces to different tablespace.

<current_tablespace> =
<new_tablespace1> =
<new_tablespace2> =

Select ' ALTER INDEX ' || owner || '.'||INDEX_NAME ||' rebuild tablespace <current_tablespace>;'
  from DBA_indexes
  where index_name in ( select segment_name from dba_segments where tablespace_name in (<new_tablespace1>,<new_tablespace2>));