Table Compression:
Usage
Usage
•Creating
compressed tables:
–CREATE TABLE
T1(id integer) COMPRESS;
•Converting
tables to compressed tables:
–ALTER TABLE
T3 MOVE COMPRESS;
•Creating
compressed tablespaces:
–CREATE
TABLESPACE tabspace_2
DATAFILE
'diska:tabspace_file2.dat' SIZE 20M
DEFAULT COMPRESS STORAGE ( … );