Re: Replication question

Even easier than looping is to pass NULL as the value for transaction id. That will clear ALL the errors at once. If you look in the Replication API refernce you'll see this for this procedure.

Regards,

Brandon

"Stephen T. Parfitt" <steve.parfitt_at_sympatico.ca> wrote in message news:3B952863.B2E4AFA3_at_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 Wed Sep 05 2001 - 23:24:42 CDT