圧縮
移動
sqlplus test/test@pdb11
select * from DBA_ILMDATAMOVEMENTPOLICIES;
select * from DBA_ILMOBJECTS;
select * from DBA_ILMPOLICIES;
create table tab05(col1 number) tablespace users;
create table tab06(col1 number) tablespace users;
create or replace function f_ilm_001 (objn IN NUMBER) return boolean
is
begin
return true;
end;
/
alter table tab05 ilm add policy row store compress basic segment on f_ilm_001;
alter table tab06 ilm add policy tier to tbs02 on f_ilm_001;
