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!

OGG equivalent to Sybase 'set replication off' functionality?

939723May 25 2012 — edited May 25 2012
Hi,

I'm currently migrating a system from ASE / Sybase Replication Server (RS) to Oracle with GoldenGate. There is a feature of RS which the system currently uses, and that is to disable replication for a batch commands. For example:

set replication off
insert into dummytable(x) values(1234)
set replication on

This has the effect of the insert command being ignored by the log reader, and thus not replicated to any source databases.

I've looked through the OGG documentation, but cannot find anything equivalent. Am I just missing something, or does this functionality not exist in OGG? Could anyone recommend an alternative approach or workaround to achieve the same result?

Thanks
Mark
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2012
Added on May 25 2012
2 comments
247 views