Re: Replication question

From: Alistair Thomson <thomson_alistair_at_yahoo.co.uk>
Date: Wed, 5 Sep 2001 10:03:14 +0100
Message-ID: <9n4pso$471$1@newsreaderg1.core.theplanet.net>

Hi Steve

Thanks for that its just what I need.

Alistair

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 - 04:03:14 CDT