GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Integrated Replication, replicate entire schema and ignoredeletes for specific table

Hi,

It is possible in the same replicate configuration to replicate a full schema and at the same time setting IGNOREDELETES for a specific table of the same schema ?

Example piece of replica.prm file:


USERID c##myuserr@PDB_DEST, PASSWORD mypass

MAP PDB_SOURCE.SCHEMAUSER.*, TARGET PDB_DEST.SCHEMAUSER.*;

IGNOREDELETES

MAP PDB_SOURCE.SCHEMAUSER.table1, TARGET PDB_DEST.SCHEMAUSER.table1.;

GETDELETES


When I prove this configuration, deletes on table1 are still being propagated on target.

Any idea ?

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