Database DataWarehousing (MOSC)

MOSC Banner

Compression Increasing the space when using "PARALLEL (DEGREE DEFAULT INSTANCES DEFAULT)" option

edited Jan 21, 2013 11:31PM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi,

Release 11.2.0.3.0

When I am compressing a table using the below query(please notice PARALLEL (DEGREE DEFAULT INSTANCES DEFAULT) option),

ALTER TABLE <table_name> MOVE SUBPARTITION <subpartition name> COMPRESS PARALLEL (DEGREE DEFAULT INSTANCES DEFAULT);

the table size has increased almost 4 times. Could you please help me understand it.

Thanks,

Vikash

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