GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to do GoldenGate initial load(for complete resynchronization ) witout truncate target table

Hi

How can I do a full synchronization without deleting data in the target table

For example, the source has 10 rows and the target has 19 rows. I have one row missing on the target. I run an initial load to replicate the missing row, but the row is still not replicated.

Here are the parameters of the replicate

replicat iu_rep1

userid ggate,password pass

OVERRIDEDUPS

REPERROR(60,TRANSABORT MAXRETRIES 999 DELAYSECS 120)

MAP tableA, target tableB;

Maybe some options still need to be added to the replicate parameters?

Thanks

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center