Limitation of 250 columns for Compression in Oracle 12c R1.
Hello Team,
We have a table having 390 columns. Earlier we were running our database on Oracle 11gR2 which has a restriction on 250 columns to be able to perform table compression. We recently migrated to Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production. I learnt this limitation of 250 columns for compression has been lifted in 12c. We tried performing a compression on one of the partitions of a table having 390 columns but it actually increased the space after compression.
We tried below 2 options to compress one of the partitions - both increased the space after compression - so the behavior is same as what was on Oracle 11gR2.