Any advice on synching 6 million rows?

From: Parichai Kalari <pkalari_at_abbnm.com>
Date: Tue, 18 Jan 2000 10:21:50 -0600
Message-ID: <3884931E.BEAFB4DA@abbnm.com>

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 - 10:21:50 CST