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