Compression Increasing the space when using "PARALLEL (DEGREE DEFAULT INSTANCES DEFAULT)" option
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