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
yugamore
Messages: 23
Registered: December 2006
Junior Member
I have created a Index,with following command:
create index SURVEY_EMP_NDX on PLI2_T_RESPONSE (SURVEYID,EMPID)

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
storage
(
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
Littlefoot
Messages: 21823
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 Dec 04 17:53:14 CST 2024