Oracle Database Discussions

Hi All,

When moved all partitioned indexes from tablespace to another , all partition indexes became unusable state.
i used below query to move those partitioned indexes to another tablespace.

"ALTER TABLE SAL_DL MOVE PARTITION P_20020102 TABLESPACE B_TABLESPACE;"

and i verified the the the status of the indexes in dba_ind_partitions table , But the partition index became unusable .
note : SAL_DL is an IOT table and all indexes are partitioned index.

is this the correct way to move the partition indexes to another table space .?

please let me know if i made any mistake while moving

Thanks
Sree