RE: Merge Partition Question

Don,

  When you merge range partitions, the partition definitions don't get merged.
You can merge range partition A and range partition B to partition B if the definition
of partition B supports the data from parition A.

 As an example if you two range partitions

 20050617 - Defined as less than June 17, 2005  20050618 - Defined as less than June 18, 2005

you can merge the partition 20050617 to 20050618. But you cannot merge the other way
because the definition of 20050617 may not support the data in 20050618.

Vincent

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Don Doo Sent: Monday, July 18, 2005 9:56 PM
To: oracle-l_at_freelists.org
Subject: Merge Partition Question

>From the Oracle 9.2 manual the Merge Partition Syntax is

ALTER TABLE [schema.]table
MERGE PARTITIONS partition1, partition2
[INTO PARTITION [new_partition] [partition_description]]

Is it possible to merge two partitions on date ranges into one of them - Like Parition 1 (for todays data) merged into partition 2 (Month-to-date) partition - and the definition of partitions also get merged?

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l