Data compression

We run several queries to insert data into compressed table from the same source table as below.

spool compression_case
drop table hah_compr1;
drop table hah_compr2;
drop table hah_compr3;
drop table hah_compr4;

create table HAH_COMPR1 compress tablespace hah_y2009d
 as
select * from HEBROS_ACCOUNT_HIST_ARCH where 1=2;

create table HAH_COMPR2 compress tablespace hah_y2009d
 as
select * from HEBROS_ACCOUNT_HIST_ARCH where 1=2;

create table HAH_COMPR3 compress tablespace hah_y2009d
 as
select * from HEBROS_ACCOUNT_HIST_ARCH where 1=2;

create table HAH_COMPR4 compress tablespace hah_y2009d
 as
select * from HEBROS_ACCOUNT_HIST_ARCH where 1=2;