Database DataWarehousing (MOSC)

MOSC Banner

incorrect partition compression value

edited Dec 4, 2013 7:09AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hello,
I have some tables compressed and recently we did a big reorg to move all of them to a new tablespace structure.
After we finished, I realized that all the partitions and subpartitions have the compression level that I wanted (mostly hcc and nocompress) , but I see some weird information on the partition level. 
For some of them I see compress for oltp, and we never, or at least I don't remember setting it up like that.
Default table compression is fine and also at subpartition level, so my question is do I need to worry for the partition level values?

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