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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Don Doo Sent: Monday, July 18, 2005 9:56 PM To: oracle-l@xxxxxxxxxxxxx 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? -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l