Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> how to move index to another tablespace without rebuild
I have a partitioned index and I need to move it to another tablespace.
I tried
alter index user1.table1_pk
modify default attributes for partition year_2000
tablespace indx;
ERROR at line 1:
ORA-14288: index is not partitioned by Composite Range method
Then I tried
alter index rtms.HISTORICAL_RTMS_PK
modify partition year_2000
tablespace indx;
ERROR at line 3:
ORA-14050: invalid ALTER INDEX MODIFY PARTITION option
Do I really have to rebuild it? It is such a huge index.
Thanks for your help.
-- Sent by dbadba62 from hotmail included in com This is a spam protected message. Please answer with reference header. Posted via http://www.usenet-replayer.com/cgi/content/newReceived on Wed Apr 04 2001 - 15:46:51 CDT