Re: Multi-master replication
From: ddf <oratune_at_msn.com>
Date: Fri, 30 Jan 2009 05:43:08 -0800 (PST)
Message-ID: <2d8dbda1-04be-45e0-9583-e62de7018e89_at_n33g2000pri.googlegroups.com>
On Jan 29, 11:56 pm, "Beginner" <begin..._at_nospam.com> wrote:
> "ddf" <orat..._at_msn.com> wrote in message
>
> news:60aa0bd8-417f-4fc8-a887-9c842ce964d1_at_e1g2000pra.googlegroups.com...
> On Jan 28, 11:00 pm, "Beginner" <begin..._at_nospam.com> wrote:
>
> > Hi there,
>
> > I need to remove some "push" entries from replication queue, don't ask
> > why.
>
> > How could I locate entries concerning certain table and certain site.
>
> > TIA
>
> > C
>
> Which release of Oracle???
>
> David Fitzjarrell
>
> Hi,
>
> release is 10.2EE
>
> C
Date: Fri, 30 Jan 2009 05:43:08 -0800 (PST)
Message-ID: <2d8dbda1-04be-45e0-9583-e62de7018e89_at_n33g2000pri.googlegroups.com>
On Jan 29, 11:56 pm, "Beginner" <begin..._at_nospam.com> wrote:
> "ddf" <orat..._at_msn.com> wrote in message
>
> news:60aa0bd8-417f-4fc8-a887-9c842ce964d1_at_e1g2000pra.googlegroups.com...
> On Jan 28, 11:00 pm, "Beginner" <begin..._at_nospam.com> wrote:
>
> > Hi there,
>
> > I need to remove some "push" entries from replication queue, don't ask
> > why.
>
> > How could I locate entries concerning certain table and certain site.
>
> > TIA
>
> > C
>
> Which release of Oracle???
>
> David Fitzjarrell
>
> Hi,
>
> release is 10.2EE
>
> C
'10.2EE' doesn't say much as to which release and patch level you're running.
You MAY be stuck executing
dbms_defer_sys.nullify_trans_to_destination for the site in question,
then when the problem is resolved running
dbms_defer_sys.push_with_catchup to that same location. I find no way
to isolate particular queue entries based upon destination and table.
David Fitzjarrell Received on Fri Jan 30 2009 - 07:43:08 CST