Moving Index To Different Tablespace
144424May 14 2003 — edited May 14 2003I created a table using:
create table employee (eid number(10) primary key, ename varchar2(15), esex char(1));
create index e_esex_id on employee(esex);
It has created two indexes on E_DATA since the default tablespace for that user is E_DATA. But, I want to move those indexes to different tablespace called E_INDEX. I used the following scripts:
ALTER INDEX SYS_C004910 REBUILD PARAMETERS('TABLESPACE=E_INDEX');
ALTER INDEX ESEX_ID_IDX REBUILD PARAMETERS('TABLESPACE=E_INDEX');
But, it is givinng the following error:
ORA-29870: specified options are only valid for altering a domain index
Any help ?
Thanks.
PS:I dont want to drop the table and recreate it again.