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?

Improve this question
2

1 Answer 1

Reset to default
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.

Improve this answer
1
  • 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
    Commented May 16, 2012 at 15:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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