You can't MOVE indexes to another tablespace. You have to REBUILD indexes to move them!
Correct :
SELECT
'ALTER INDEX ' || index_name || ' REBUILD TABLESPACE P1ECP1_LT96K_X;'
FROM dba_indexes WHERE tablespace_name='P1ECP1_LT96K_D';
|
Results 1 to 5 of 5
Threaded View
|
Click Here to Expand Forum to Full Width |