1

I have been reading the GoldenGate 11g R2 installation guide and it states:

Non-supported objects and operations in Oracle DML:

[...] Synonyms [...]

But I see in the next section that DDL operations are supported, so CREATE, ALTER, etc...

So, what is exactly a DML operation against a synonym and how is it not supported?

1

From reading the documentation, it looks like DML on a synonym for a normal object will not be replicated. For example, you have a table called FOO & a synonym called BAR that points to FOO. An INSERT into FOO will succeed, but an INSERT into BAR will not, as it is a synonym for another table & not a real base table.

Test this in your dev environment to verify.

  • 1
    Tested, and it works! I did several INSERT, UPDATE against the source, and they were replied in the target, so I still don't have a clue of what they mean by DML against synonym... – Eugenio Cuevas May 16 '12 at 15:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.