Category Archives: oracle advanced compression

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

CHILD TABLE DOESN’T INHERIT PARENT’S COMPRESSION ATTRIBUTE AFTER SPLITTING PARENT PARTITION

Issues: When split a partition of a reference parent table, the compression attribute “compress for OLTP” is not inherited by childĀ partitions. Instead,it changes into “compress fo BASIC’ by default. The test case below is on 11.2.0.4 database. We have two … Continue reading

Posted in oracle advanced compression, Oracle DBA Practice, Partitioning | Tagged , , , | Leave a comment