Daily Archives: June 7, 2017

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

ORA-14451: unsupported feature with temporary table

It looks like temporary table can nor be compressed by using Oracle Advanced Compression Features in 12.1.0.2. SQL> alter session set current_schema=jamesh; SQL> CREATE GLOBAL TEMPORARY TABLE TEST_TBL ( id number, name varchar(20), CONSTRAINT TEST_TBL_PK PRIMARY KEY (id) ENABLE ) … Continue reading

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