Big Tables in Campus Solutions

Major challenge that we faced while moving from SQL Server to Oracle was how to get big tables

from SQL Server into Oracle in the fastest time, my time slot was just 14 hours. 

There were like 11 big tables(large volume of data) - and peoplesoft has provided a purge process for only one table.

The below 11 tables were taking like 16 hrs to export and import. 

1. PS_CLASS_ATTENDNCE

2. PS_FEE_CLASS_PRICE - Purged those rows with CLASS_PRICE =0 and drop_dt = null

3. PS_SA_REPORT_RSLT - PeopleSoft (now Oracle) has provided a purge process.

4. PS_CREDIT_HISTORY

5. PS_CALC_MESSAGES

6. PS_STDNT_BUDGET_IT

7. PS_FA_FATERM_AUDIT

8. PS_COMMUNICATION

9. PS_STDNT_FA_tERM

10. PS_ITEM_LINE_SF

11. PS_ITEM_SF_GL_HIST

We used the standby database  which was in sync with the production and started the export and import simultaneously to fit the time window.