Re: Multi-master replication
Date: Tue, 03 Feb 2009 07:52:57 GMT
"ddf" <oratune_at_msn.com> wrote in message
On Jan 29, 11:56 pm, "Beginner" <begin..._at_nospam.com> wrote:
> "ddf" <orat..._at_msn.com> wrote in message
> 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
> release is 10.2EE
'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.
How about this kind of approach:
set pages 10000
set lines 160
set echo off
select 'exec dbms_defer_sys.DELETE_TRAN(''' || a.deferred_tran_id ||''','''||a.dblink || ''');'
from deftrandest a, defcall b
where a.deferred_tran_id=b.deferred_tran_id and a.dblink='DEST_SITE'
and packagename='TABLE_NAME$RP' ORDER BY DELIVERY_ORDER;
spool off Received on Tue Feb 03 2009 - 01:52:57 CST