how to move index to another tablespace without rebuild
From: <u132781982_at_spawnkill.ip-mobilphone.net>
Date: Wed, 04 Apr 2001 20:46:51 GMT
Message-ID: <l.986417211.1392761230_at_[198.138.198.252]>
Date: Wed, 04 Apr 2001 20:46:51 GMT
Message-ID: <l.986417211.1392761230_at_[198.138.198.252]>
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 - 22:46:51 CEST