RE: Merge Partition Question

Well I don't see how that could be done Don using that syntax. You need to have the same partitioning key on both partitions to merge them.

However you could always insert from the unwanted partition to the new partition. Then drop the original partition.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Don Doo Sent: 19 July 2005 02:56
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