How to archive the partition table rows and delete them?
I need to do this without dropping the partition with minimal archive and redo generation, appreciate your ideas...
1. Archive table STORES to STORESBKP_2009
2. Delete records from STORES where week_id <= 200913
3. Archive table FACT to FACT_BK2009
4. Delete records from FACT where time_key<= 328
5. Archive table FACTORD to FACTORD_BK2009
6. Delete records from FACTORD where time_key<= 328
7. Archive table FACTPRO to FACTPRO_BK2009
8. Delete records from FACTPRO where time_key<= 328
9. Archive table FACWK to FACTWK_BU_BK2009
10. Delete records from FACTWK where time_key<= 452
Thanks,
Bala.