CODE EXAMPLE FOR SQL

oracle swap partition

-- ORACLE partition swap
ALTER TABLE target_table EXCHANGE PARTITION target_partition
WITH TABLE source_table;
/*
. source_table and target_table have the same structure 
	(columns, data types, respect constraints).
. indexes have to be rebuilt
*/