Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Merge Partition Question

Merge Partition Question

From: Don Doo <doodon_at_gmail.com>
Date: Mon, 18 Jul 2005 21:55:31 -0400
Message-ID: <36f8e4b0050718185515b7134b@mail.gmail.com> 





>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


Received on Mon Jul 18 2005 - 20:57:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US