Tag Archives: COMPRESSION ATTRIBUTE

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