* 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