DB Wiki

User Tools

Site Tools

Trace:
ilm

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
ilm [2016/02/09 13:43] – z0hpvkilm [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 28: Line 28:
 ROW STORE COMPRESS ADVANCED ROW STORE COMPRESS ADVANCED
 SEGMENT AFTER 1 YEARS OF CREATION;</code> SEGMENT AFTER 1 YEARS OF CREATION;</code>
 +
 +Compress Rows if they haven't been changed for 45 days
 +<code>ILM ADD POLICY
 +ROW STORE COMPRESS ADVANCED
 +SEGMENT AFTER 45 DAYS OF NO MODIFICATION;</code>
 +
 +There can only be one row level policy for a segment.\\
 +The view USER_ILMPOLICIES shows details of all existing ADO policies.\\
 +
 +Disable all ADO policies for the whole database
 +<code>BEGIN
 +DBMS_ILM_ADMIN.DISABLE_ILM;
 +END;</code>
 +
 +Disable a single policy on a table
 +<code>ALTER TABLE t1 ILM DISABLE_ALL;
 +ALTER TABLE t1 ILM disable <policy_name>;</code>
  
  
  
ilm.1455025409.txt.gz · Last modified: 2025/03/08 22:23 (external edit)