Table Compression To compress a table use: ALTER TABLE t1 MOVE compress;
{"Image DocumentName": "Table CompressionTo compress a table use: ALTER TABLE t1 MOVE compress; To compress a table partition use: ALTER TABLE T1 MOVE PARTTION P1 compress;", "Image ImageDescription": "Alternative way CTAS compress: CREATE TABLE T1 compress AS SELECT   FROM T1_UNCOMPRESSED; Table or partition not available (locked) during move. Use DBMS_REDEFINITION for online move.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}