RE: Merge Partition Question

I think that is what I said Vincent but you explained it much better than I did.

J

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chazhoor, Vincent Sent: 19 July 2005 14:38
To: 'doodon_at_gmail.com'; oracle-l_at_freelists.org Subject: RE: Merge Partition Question

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

--
http://www.freelists.org/webpage/oracle-l