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

[diwakar]

Hi Slimdave,

I was just breaking my head in the next step (after what I had posted) but just got stuck on that. Your reply is helpfull to a great extent in solving the problem.

Could you point out the mistake/edit what I have given below if I have proceeded in the correct way:


select
'select
'alter index' ||index_name|| 'move tablespace P1ECP1_LT96K_X ;'
from dba_indexes where table_name='''||table_name||''';'
from dba_indexes where tablespace_name='P1ECP1_LT96K_D'
;


Thanks and Regards,

K.Diwakar