title: Disable compression on partitioned index?
body: <p>I'm trying to disable compression in a database, and I've been able to do so for everything except for partitioned indexes at the index level.</p>
  
  <p>I've run these queries:</p>
  
  <pre><code>ALTER TABLE &lt;table_name&gt; MOVE NOCOMPRESS;
  
  ALTER INDEX &lt;index_name&gt; REBUILD NOCOMPRESS;
  
  ALTER INDEX &lt;index_name&gt; REBUILD PARTITION &lt;partition_name&gt; NOCOMPRESS;
  
  ALTER INDEX &lt;index_name&gt; MODIFY PARTITION &lt;partition_name&gt; NOCOMPRESS;
  
  ALTER INDEX &lt;index_name&gt; REBUILD SUBPARTITION &lt;subpartition_name&gt;;
  </code></pre>
  
  <p>To ensure that no compression is being used from the partition level downward, but the query</p>
  
  <pre><code> select * from dba_indexes where compression = 'ENABLED';
  </code></pre>
  
  <p>Still returns results, and I can't use <code>ALTER INDEX ... REBUILD</code> here, because of <code>"ORA-14086: a partitioned index may not be rebuilt as a whole."</code> I was hoping that I could use something like <code>'ALTER INDEX ... MODIFY DEFAULT ATTRIBUTES NOCOMPRESS'</code>, but that doesn't seem to work.</p>
  
  <p>Is there another way to disable compression at the index level without manually rebuilding each index?</p>