Sunday, September 12, 2010

How to exchange partition between two partitioned tables?

* Please note you cannot exchange partititon between two partitioned tables.*

-- will move data from PARTITION_1 to normal table

ALTER TABLE PARTITIONED_TABLE_1 EXCHANGE PARTITION PARTITION_1 WITH TABLE NORMAL_TABLE WITHOUT VALIDATION;

-- will move data into PARTITION_10 of this table

ALTER TABLE PARTITIONED_TABLE_2 EXCHANGE PARTITION PARTITION_10 WITH TABLE NORMAL_TABLE WITHOUT VALIDATION;

No comments:

Post a Comment