create huge tablespace biphug path '/data/dm8/instance/DAMENG/bip01.dbf' ;
select * from SYS."V$DATAFILE"
create huge table iuap_apdoc_coredoc.productdetail_huge STORAGE(WITH DELTA) tablespace biphug as select * from iuap_apdoc_coredoc.productdetail;
drop table iuap_apdoc_coredoc.productdetail_huge;
create huge table iuap_apdoc_coredoc.productdetail_huge STORAGE(WITH DELTA) tablespace biphug COMPRESS LEVEL 1 as select * from iuap_apdoc_coredoc.productdetail;

壓縮前2566M

壓縮后680M