Partition exchange
From: Ken Naim <kennaim_at_gmail.com>
Date: Wed, 12 Mar 2008 20:35:01 -0400
Message-ID: <AC2DA3D2949A44FD94703686BCDDF6DA@KenPC>
Date: Wed, 12 Mar 2008 20:35:01 -0400
Message-ID: <AC2DA3D2949A44FD94703686BCDDF6DA@KenPC>
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
10.2.0.3 and is running on Solaris 10.
Thanks,
Ken
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 12 2008 - 19:35:01 CDT