script-move a list of indexes - particular set of tables in a tablespace

[slimdave]

H'mmm. I suspect you didn't try hard to solve this yourself, but anyway ...

select
   'Alter index '||owner||'.'||index_name||' rebuild tablespace my_tablespace;'
from
   dba_indexes
where
   (owner,table_name) in 
      (
      select
         owner,table_name
      from
         dba_tables
      where
         tablespace_name = 'P1ECP1_LT96K_D' and
         owner = 'DIP_S01'
      )
/