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