Database DataWarehousing (MOSC)

MOSC Banner

Limitation of 250 columns for Compression in Oracle 12c R1.

edited May 5, 2018 5:02AM in Database DataWarehousing (MOSC) 4 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center