alter index CONTROL_MST_CTRLID_PRK rebuild tablespace UF5;



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