ADO compression

[Roshan]

Oracle Database 12.2.0
RHEL 7.4

Hi Erman,

when compressing a partition using
ALTER TABLE MOBILE_DATA MOVE PARTITION MOBILE_DATA_2018_01 TABLESPACE TESTBI COMPRESS FOR ALL OPERATIONS;

COMMIT;

 

I see it is requiring additional space during compression. We would expect the space to decrease during compression.

 

Error starting at line : 7 in command -

ALTER TABLE MOBILE_DATA MOVE PARTITION MOBILE_DATA_2018_01 TABLESPACE TESTBI COMPRESS FOR ALL OPERATIONS

Error report -

ORA-01652: unable to extend temp segment by 1024 in tablespace TESTBI

01652. 00000 -  "unable to extend temp segment by %s in tablespace %s"

*Cause:    Failed to allocate an extent of the required number of blocks for

           a temporary segment in the tablespace indicated.

*Action:   Use ALTER TABLESPACE ADD DATAFILE statement to add one or more

           files to the tablespace indicated.

[ErmanArslansOracleBlog]

You are complaining about temp usage during compression, right?

It may be related with your parallelism settings.
When the compression is done in parallel, temp space will be requested.
More parallel workers, more temp space..
If so, you may set the session maximum degree of parallelism down.. (you can also decrease it in the table level)

Did you check your environment according to the info above?