sqlplus test/test@pdb11
CREATE OR REPLACE FUNCTION my_custom_ado_rules (objn IN NUMBER) RETURN BOOLEAN
is
begin
return true;
end;
/
※パラメータにnumber型必要
create table test_pol(col1 number) tablespace users;
alter table test_pol ilm add policy TIER TO tbs01 on my_custom_ado_rules;
insert into test_pol values(1);
commit;
select * from user_segments where SEGMENT_NAME='TEST_POL';
var task_id number
exec dbms_ilm.execute_ilm( task_id => :task_id, owner => 'TEST', object_name => 'TEST_POL');
print :task_id
select * from DBA_ILMTASKS;
select * from DBA_ILMEVALUATIONDETAILS;
select * from DBA_ILMRESULTS;
select * from user_segments where SEGMENT_NAME='TEST_POL';
