Hi ,

The Table compression works for Partitioned and non-partitioned
tables the syntax for Non-Partitioned tables is
the statement "ALTER TABLE MOVE COMPRESS"
is going to compress the existing rows and also the New rows to be
added

"ALTER TABLE EMP
MERGE PARTITIONS P_2000,P_3000 INTO PARTITION
P_2000_3000_compress
COMPRESS;" is going to merge and compress the partitions
saving lot of disk space.

for a Partitioned Tables u can only merge and compress or if u want to
compress a partitioned table ur going to loose the partitions
"create table
tablespace
COMPRESS
as
select * from "

I have worked on Table Compression feature the results are amazing!!
The Table size was reduced from 800MB to 120MB and 230MB to 32 MB
The query performance is also good.. these results were done on
Partitioned Tables!!! all partitions were removed... This is
recommended on Tables where no DMLs are performed. If i come to know
any results i'll post them

compression for partitioned tables
USE THIS way and also remove the clause COMPRESS in this definition
load the data in both the tables see the table size i did not find and
difference in the table size!!!

CREATE TABLE EMP
(EMPNO NUMBER(4) NOT NULL,
ENAME CHAR(30),
AGE NUMBER(3)
)
COMPRESS
PARTITION BY RANGE(EMPNO)
(
PARTITION P_1000 VALUES LESS THAN (1000)
TABLESPACE
STORAGE PARAMETERS < >
),
(
PARTITION P_2000 VALUES LESS THAN (2000)
TABLESPACE
STORAGE PARAMETERS < >
),
(
PARTITION P_3000 VALUES LESS THAN (3000)
TABLESPACE
STORAGE PARAMETERS < >
),
Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules



Click Here to Expand Forum to Full Width