Re: Partition exchange
- From: Darrell Landrum <darrell@xxxxxxxxxxx>
- Date: Wed, 12 Mar 2008 19:46:51 -0500
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.
Regards,
Darrell
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
10.2.0.3 and is running on Solaris 10.
Thanks,
Ken
Other related posts:
