Re: Any advice on synching 6 million rows?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 18 Jan 2000 14:52:42 -0800
Message-ID: <3884EEBA.18785149@us.oracle.com>

There is also the DBMS_RECTIFIER_DIFF.DIFFERENCES and RECTIFY procedures as an option, but you need to set one site as the "true" version.

HTH. Pete

Parichai Kalari wrote:

> Hi all!
>
> We have two tables in a replicated environment(master-master)that went
> out of sync, each with about 6 million rows.
>
> Any suggestions as to how to sync them up? Which method would be
> advisable? Doing and export/import(with commit =Y and large batch count
> - to prevent rollback segs problem) or doing a minus and comparing the
> two tables(which takes forever). Indexes being considered in both the
> methods.
>
> Did any one ever tried one of those above or any other way with 6
> million rows? (Digital Unix 4.0 environment with Oracle 7.3.2)
>
> Any suggestions are welcome!
>
> Thanks

Received on Tue Jan 18 2000 - 16:52:42 CST