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
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
Other related posts:
