drop table tab1 purge;
drop table tab2 purge;
create table tab1(col1 number);
create table tab2(col1 number);
alter table tab1 row store compress basic;
alter table tab2 row store compress advanced;
select owner,table_name,blocks,compress_for from dba_tables
where table_name like 'TAB%';
