1-- ORACLE partition swap
2ALTER TABLE target_table
3EXCHANGE PARTITION target_partition
4WITH TABLE source_table;
5/*
6. source_table and target_table have the same structure
7 (columns, data types, respect constraints).
8. indexes have to be rebuilt
9*/