Database DataWarehousing (MOSC)

MOSC Banner

How to archive the partition table rows and delete them?

edited Oct 30, 2013 1:08AM in Database DataWarehousing (MOSC) 7 commentsAnswered
Hi All,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center