Tag Archives: ORA-02158: invalid CREATE INDEX option

ORA-02158: invalid CREATE INDEX option

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. … Continue reading

Posted in ORA- ERRORS, oracle advanced compression | Tagged , , | Leave a comment