Re: Replication question

From: Stephen T. Parfitt <steve.parfitt_at_sympatico.ca>
Date: Tue, 04 Sep 2001 15:15:47 -0400
Message-ID: <3B952863.B2E4AFA3@sympatico.ca>

Alistair:

You can use builtin procedure DBMS_DEFER_SYS.DELETE_ERROR to delete these errors. You need to supply the deferred transaction id so you may want to code a PL/SQL program to loop through the results of a query on all the SYS.DEFERROR rows that are related to the group that has been dropped.

Steve

Alistair Thomson wrote:
>
> Oracle 8.0.6 Enterprise Edition
> NT 4
>
> A replicated group was dropped before the deferred transaction queue was
> cleared, this took a while but has eventually cleared. I still can't get the
> new replicated group to replicate.
>
> I checked the local errors folder and there are zillions of errors for the
> replicated group that no longer exists!
>
> My question is:
>
> Can I delete these records from base tables rather than using the GUI tool
> which is soooo slooooooowwwwww. Is there a procedure that can be run to
> clear these records down?
>
> Thanks for any help.
>
> Alistair
Received on Tue Sep 04 2001 - 14:15:47 CDT