Differences

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

--- ilm [2016/02/09 13:56] – [Automatic Data Optimisation] z0hpvk
+++ ilm [2016/02/09 14:00] (current) – [Automatic Data Optimisation] z0hpvk
@@ Line 35: / Line 35: @@
 There can only be one row level policy for a segment.\\
-The view USER_ILMPOLICIES shows details of all existing ADO policies.
+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>