ALTER TABLE historical_newsales EXCHANGE PARTITION FOR (TO_DATE('01-JAN-2007','dd-MON-yyyy')) WITH TABLE historical_newsales2 INCLUDING INDEXES;