Differences

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

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