Oracle large table replication solution Stored Procedure Implementation

Implementation of the stored procedure for the Oracle large table replication solution:

1. ProcedureMakePayPlayIraBakNewIs
3. V_num number;
4. Begin
6. Vanceinfo. gmac_log_pro.setloginfo ('Makepayplayirabaknew',
7. '123',
8. '9',
9. Sysdate,
10. 'Makepayplayirabaknew execution start');
11. V_num: = 0;
12. Select Count(1)
13. IntoV_num
14. FromUser_tables
15. WhereTable_name ='Gmac _ PAYPLAY_IRA_HIS';
16. If (v_num> 0)Then
17. ExecuteImmediate'Drop TABLE GMAC_PAYPLAY_IRA_HIS';
18. EndIf;
20. ExecuteImmediate'Create TABLE GMAC_PAYPLAY_IRA_HIS as select * FROM gmac_payplay';
22. Vanceinfo. gmac_log_pro.setloginfo ('Makepayplayirabaknew',
23. '123',
24. '0',
25. Sysdate,
26. 'Makepayplayirabaknew execution completed successfully');
28. Exception
29. WhenOthersThen
30. Vanceinfo. gmac_log_pro.setloginfo ('Makepayplayirabaknew',
31. '123',
32. '9',
33. Sysdate,
34. Substr (sqlerrm, 1,200 ));
35. EndMakePayPlayIraBakNew;