12.2 DBMS_ILM heatmap ado issues
I am testing automatic data optimization polices using dbms_ilm. So I pick a single table in my database and do this:
ALTER TABLE ALERT_CMPZAUFA18A_7_8
ILM ADD POLICY ROW STORE COMPRESS ADVANCED SEGMENT
AFTER 3 MONTHS OF NO ACCESS;
ALTER TABLE ALERT_CMPZAUFA18A_7_8
ILM ADD POLICY TIER TO URET;
/*
Create a task and execute it, return the task_id
*/
variable taskId NUMBER;
begin
DBMS_ILM.EXECUTE_ILM ( owner => 'URET01',
object_name => 'ALERT_CMPZAUFA18A_7_8',
task_id => :taskId,
subobject_name => NULL,
policy_name => DBMS_ILM.ILM_ALL_POLICIES,
execution_mode => DBMS_ILM.ILM_EXECUTION_ONLINE);
end;
/
print :taskId;