×To enable table compression in Oracle 19c, you can:
- Enable compress for the whole table then move the subpartitions.
- Add COMPRESS clause while creating a table. By default, every table is created with NOCOMPRESS option.
- Perform compression on several partitions or a complete partitioned heap-organized table. You can do this compression by either defining a complete partitioned table as being compressed, or by defining it on a per-partition level.
,Enable compress for the whole table then move the subpartitions.
ALTER TABLE SCH.STU_DATA compress for all operations ; ALTER TABLE SCH.STU_DATA MOVE SUBPARTITION whatever TABLESPACE DATA_PARTS;You must add
COMPRESS clause while creating a table. By default, every table is created with NOCOMPRESS option CREATE TABLE COMP_TEST(id number(4), std_name varchar2(20)) COMPRESS; Check compression status You can query DBA_TABLES to check compression status of a table
Compression can be performed on several partitions or a complete partitioned heap-organized table. You can do this compression by either defining a complete partitioned table as being compressed, or by defining it on a per-partition level.