Re: Notification of replication error

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 29 Jul 2003 22:50:58 GMT
Message-ID: <mTCVa.2811$vC2.1890@news02.roc.ny>

"Mark Perona" <mperona_at_earthlink.net> wrote in message news:5111bb05.0307291356.1817c68c_at_posting.google.com...
> Does anyone know how I can set it up so that an email is sent to an
> administrator if a conflict occurs during replication? It would also
> be nice to tell the administrator if the error was handled or not.

Look in the Oracle replication API manual, there it is explained how to set up a notification table. This can be useful to record replication conflicts which could or could not be handled.

Alternatively: Monitor deferror table. Entries in this table point to any conflict error. You can also monitor the alert log, the error notification is recorded out there also.

You can choose your preferred method of monitoring .. cronjob, dbms_job ....

Anurag Received on Tue Jul 29 2003 - 17:50:58 CDT