 Need to change table space of existing Index [message #213710] |
Fri, 12 January 2007 00:24  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
