move index to another tablespace

move index to another tablespace

 

  


what is the command to move index from one tablespace from another

it gives me error like that

alter index CONTROL_MST_CTRLID_PRK tablespace UF5 rebuild;
alter index CONTROL_MST_CTRLID_PRK tablespace UF5 rebuild
*
ERROR at line 1:
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option


Any comments





Regards,
Vipul Vaja,
Database Administrator (OCP)

DecisionCraft Analytics (India) Limited
www.decisioncraft.com
601, Shapath, Opposite Rajpath Club
Sarkhej Gandhinagar Highway, Ahmedabad 380015
Phone:- +91-79-26870656/57/58
Ext No :- 122,129
Cell:- 9825426805

v.[Email address protected]
[Email address protected]





Oracle LazyDBA home page