ALTER INDEX CONTROL_MST_CTRLID_PRK REBUILD LOGGING TABLESPACE UF5 ;

-----Original Message-----
From: Vipul
[mailto:oracledba-ezmlmshield-x74172163.[Email address protected]
Sent: Thursday, December 01, 2005 12:33 AM
To: LazyDBA Discussion
Subject: 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]






--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page