RE: Partition exchange

From: Ken Naim <>
Date: Wed, 12 Mar 2008 23:20:17 -0400
Message-ID: <1D76B0DCA16241F8804D615CF0535327@KenPC>

I could understand it if the full scan was on a partition but all 18 partitions are being scanned. Also the partition after the exchange is the right tablespace (same one that it was in when it was a heap table). So that doesn't make much sense to me.  


From: [] On Behalf Of Darrell Landrum
Sent: Wednesday, March 12, 2008 8:47 PM
Subject: Re: Partition exchange  

Hey Ken,  

When doing the partition exchange to a different tablespace, all of the data has to be moved. Data dictionary updates "only" would only apply if keeping the segments in the same tablespace.  



On Mar 12, 2008, at 7:35 PM, Ken Naim wrote:

I am in the process of moving the partitions of a table from ASSM to a non-assm tablespace using the partition exchange method (create non partitioned table, indexes, constraints etc.). When I do the alter table exchange partition including indexes without validation command it runs for hours, doing a full table scan on all the partitions of the partitioned table which takes many hours. I understood that just the data dictionary is updated, and it should take a few seconds. Primary Wait event is db file scattered read. Can anyone shed some light on this phenomenon. DB version is and is running on Solaris 10.



Received on Wed Mar 12 2008 - 22:20:17 CDT

Original text of this message