Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to move index to another tablespace without rebuild

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@[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/new
Received on Wed Apr 04 2001 - 15:46:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US