Database Administration (MOSC)

MOSC Banner

12.2 DBMS_ILM heatmap ado issues

edited Feb 21, 2019 10:46AM in Database Administration (MOSC) 5 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center