Moving UK index on IOT to a new TS

Hello,

I have an IOT table as defined below

Table Definition

create table temp
(
INV_NUM VARCHAR2(30) not null,
INV_REF NUMBER(9) not null,
constraint temp_PK primary key (INV_NUM)
)
organization index;

alter table temp
add constraint temp_UK2 unique (INV_REF)
using index
tablespace USERS
);

What I did?

I moved the table temp to a tablespace as

alter table temp move tablespace new_TS;

successful

What's going wrong?

I tried to move the temp_UK2 index to the same TS but getting the following error, what is the solution?

SQL> alter index temp_UK2 tablespace BF_temp rebuild online;
alter index temp_UK2 tablespace BF_temp rebuild online
*
ERROR at line 1:
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

Regards
BB

Quote:

---

alter index index_name rebuild tablespace tablespace_name online;

---

Thanks,

SQL> alter index TEMP_UK2 rebuild BF_TEMP online;
alter index TEMP_UK2 rebuild BF_TEMP online
*
ERROR at line 1:
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

I think we need to recreate the index or probably thinking of reorganize the table in one go....

alter index TEMP_UK2 rebuild tablespace BF_TEMP online;

Thanks,