11gR2(188.8.131.52) Linux 5 64bit
Is there any way to create a general error handler that will handle all and any tables that have errors during the apply process as opposed to creating several error handlers for several tables? You can create an error handler for 1,2, 3 or more tables and it may resolve your issue, however, you don't know if some other table will have an error in the future or not.
Please see below links
hope it clears all your doubts
Time for Change: Migrate your Non-RAC Database to RAC
Send mails using UTL_SMTP in Oracle