ADO compression

Posted by Roshan on Dec 14, 2018; 10:34am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ADO-compression-tp7007.html

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.