Re: ** way to delete entry on replication

Hi,
You should be able to see the error in the deferror view, so to remove it connect as the replication administrator and use: execute dbms_defer_sys.delete_error('<deferred_tran_id>','<destination>'); Where <deferred_tran_id> and <destination> are as listed in deferror.

Once executed you may need to quiesce and resume the site using: execute dbms_repcat.suspend_master_activity('<rep_group>'); execute dbms_repcat.resume_master_activity('<rep_group>');

To prevent future occurrences investigate conflict resolution as per the documentation and Metalink advice.

*note* the above syntax and commands are from memory and totally untested, but I did just do it earlier today!

Cheers,

Stu.

On 8/31/06, A Joshi <ajoshi977_at_yahoo.com> wrote:
>
> Hi,
> Is there a way I can delete a defcall entry on advanced replication. I
> have one update entry in a transaction that is not going thru with data not
> found error. I see that data is there and matching. cannot however delete
> the error itself since it has other entries which are needed. I would like
> to just ignore this entry and move ahead. I Is there a way to do that? Or
> any other way around this which is blocking progress. Thanks for your help.
>
> ------------------------------
> How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
> rates.
> <http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>
>
>

--
http://www.freelists.org/webpage/oracle-l