Tried to apply Oracle Advanced Compression Feature onto IOT tables in 12.1.0.2, then got this error.
SQL> CREATE TABLE TEST_IOT_TBL
( id number,
sex char(1),
name varchar2(20),
CONSTRAINT TEST_IOT_TBL_PK PRIMARY KEY (id,sex ) ENABLE
) ORGANIZATION INDEX ;
Table created.
SQL> insert into TEST_IOT_TBL values ( 1,'M','test1');
1 row created.
SQL> insert into TEST_IOT_TBL values (2,'M','test2');
1 row created.
SQL> commit;
Commit complete.
SQL> alter table TEST_IOT_TBL move compress for all operations;
alter table TEST_IOT_TBL move compress for all operations
*
ERROR at line 1:
ORA-02158: invalid CREATE INDEX option