Re: Should one include partitioning key column as first column of non-unique local index

From: Robert Klemme <>
Date: Wed, 17 Aug 2011 11:00:02 +0200
Message-ID: <>

On 17.08.2011 09:35, vsevolod afanassiev wrote:
> OK, found Metalink Note 312843.1. The only way to compress partitioned
> index is to drop and rebuild. Great.

Maybe DBMS_REDEFINITION can help. It's certainly not an easy operation though.

One way could be to copy the table (with partitions), create the compressed index on the copy and swap both tables with DBMS_REDEFINITION.

Kind regards


remember.guy do |as, often| as.you_can - without end
Received on Wed Aug 17 2011 - 04:00:02 CDT

Original text of this message