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