EXCHANGE PARTITION TABLE

EXCHANGE PARTITION TABLE :-

ALTER TABLE ORIGINAL_TABLE
EXCHANGE PARTITION TEMP_TABLE_PARTITION_NAME
WITH TABLE TEMP_TABLE
WITHOUT VALIDATION  UPDATE GLOBAL INDEXES;  

ALTER TABLE WC_TEST_TMP_FS
EXCHANGE PARTITION PERIOD
WITH TABLE  WC_TEST_TMP1_FS
INCLUDING INDEXES
WITHOUT VALIDATION;