Home » SQL & PL/SQL » SQL & PL/SQL » Need to change table space of existing Index
icon5.gif  Need to change table space of existing Index [message #213710] Fri, 12 January 2007 00:24 Go to next message
Messages: 23
Registered: December 2006
Junior Member
I have created a Index,with following command:

The was created in the default Table space MCD_DATA, Now I need to change the table space to MCD_IDX, how do I do that?

I tried using :
Alter index SURVEY_EMP_NDX
modify default attributes tablespace MCD_IDX
pctfree 10
initrans 2
maxtrans 255
initial 64K
minextents 1
maxextents unlimited

It Gives an error:
ORA-14501: Object is not partitioned.

May I know how to use the Alter Index command?

[Updated on: Fri, 12 January 2007 00:26]

Report message to a moderator

Re: Need to change table space of existing Index [message #213712 is a reply to message #213710] Fri, 12 January 2007 00:35 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ALTER INDEX survey_emp_ndx REBUILD TABLESPACE mcd_idx;
Previous Topic: Optimizer Choosing a Path with higher cost
Next Topic: SQL Querry to return database columns which got updated
Goto Forum:

Current Time: Tue Aug 22 00:11:56 CDT 2017

Total time taken to generate the page: 0.06976 seconds