Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Moving Index To Different Tablespace

144424May 14 2003 — edited May 14 2003
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2003
Added on May 14 2003
2 comments
591 views