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: 21123
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ALTER INDEX survey_emp_ndx REBUILD TABLESPACE mcd_idx;
Previous Topic: ORA-01422: exact fetch returns more than requested number of rows
Next Topic: About Procedure
Goto Forum:

Current Time: Wed Jun 28 23:03:26 CDT 2017

Total time taken to generate the page: 0.11214 seconds