Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

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?

share|improve this question
Google is quick! forums.oracle.com/forums/… – Phil May 16 '12 at 14:39
Indeed!! I posted it in both, let's see who's the fastest... ;) – Eugenio Cuevas May 16 '12 at 14:45

1 Answer

up vote 1 down vote

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.

share|improve this answer
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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