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