OGG equivalent to Sybase 'set replication off' functionality?
939723May 25 2012 — edited May 25 2012Hi,
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