Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Conditional replication

user8686720Jun 10 2014 — edited Jun 11 2014

We have a requirement that purging activity carried at the source table should not get replicated to the target. The source table is a kind of staging table which get truncated every week, but the target table should not get impacted due to this truncate operation. Goden gate version we are using is 11.2.1 on Windows OS.

Thanks

Comments

J.A.

Hi

Truncate is a DDL operation, do you have DDL replication enable ? in your OGG environment

Maybe you need a historical table on your target DB, so maybe you can create a Job to copy the Data from the target table to the historical table.

Regards

Frak!!!

you need to check if you have enable a DDL replication at the source database? if the DDL installed and enabled, you can control which DDL to capture from the extract and replicat by using DDL Include and DDL exclude parameters.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 9 2014
Added on Jun 10 2014
2 comments
1,194 views