{3 自動データ最適化}移動ポリシーを設定

演習

 

https://docs.oracle.com/cd/F19136_01/vldbg/ilm-strategy-heatmap-ado.html#GUID-DE4C9EB5-FBDC-4621-AA7B-17EBD11FBF27

     テーブルに対して指定
     表領域に対して指定

sqlplus test/test@pdb11


select * from DBA_ILMDATAMOVEMENTPOLICIES;
select * from DBA_ILMOBJECTS;
select * from DBA_ILMPOLICIES;

create table tab04(col1 number) tablespace users;
create tablespace tbs02 datafile '/oradata/orcl/pdb11/tbs02.dbf' size 10M;
create tablespace tbs03 datafile '/oradata/orcl/pdb11/tbs03.dbf' size 10M;
create tablespace tbs04 datafile '/oradata/orcl/pdb11/tbs04.dbf' size 10M;

 

alter table tab04 ilm add policy tier to tbs02;
alter tablespace tbs03 default ilm add policy tier to tbs04;