Differences

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

--- ilm [2016/02/09 13:45] – z0hpvk
+++ ilm [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 29: / Line 29: @@
 SEGMENT AFTER 1 YEARS OF CREATION;</code>
-There can only be one row level policy for a segment
+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>