1 Reply Latest reply: May 17, 2012 7:13 AM by amardeep.sidhu RSS

    DML on synonym not supported

    668264
      I have been reading the GoldenGate 11g R2 manual and it states:

      Non-supported objects and operations in Oracle DML:
      ...
      Synonyms
      ....

      But I see in the next section they are supported in DDL, so create, alter, etc...

      So, what is exactly a DML operation against a synonym and how is it not supported?
        • 1. Re: DML on synonym not supported
          amardeep.sidhu
          Eucuepo wrote:
          I have been reading the GoldenGate 11g R2 manual and it states:

          Non-supported objects and operations in Oracle DML:
          ...
          Synonyms
          I think. Suppose you are replicating a schema and it contains a synonym to some object in some other schema. GG isn't going to replicat the changes happening to this table (via this synonym).


          >
          But I see in the next section they are supported in DDL, so create, alter, etc...

          So, what is exactly a DML operation against a synonym and how is it not supported?
          By supporting DDL against a synonym it is referring to create synonym, drop synonym etc.