RE: Merge Partition Question

  • From: "Chazhoor, Vincent" <Vincent.Chazhoor@xxxxxxxx>
  • To: "'doodon@xxxxxxxxx'" <doodon@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 19 Jul 2005 09:37:30 -0400


  When you merge range partitions, the partition definitions don't get
You can merge range partition A and range partition B to partition B if the
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.


-----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

Other related posts: