Merge Partition Question

  • From: Don Doo <doodon@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 18 Jul 2005 21:55:31 -0400

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

Other related posts: