2 Replies Latest reply: Jul 18, 2013 6:40 AM by SANCHITGUPTA RSS

    Goldengate DDL Capture only for 'ADDING and DELETING' a column




      Source Oracle 11.2

      GG Version: 11.2

      Target Oracle 11.2



      I am configuring the replication between oracle-oracle and regarding DDL replication ,for few tables , in addition to the DML replication , i want to capture only the DDL's related to the structure changes to the table (only adding or deleting a column) and noting else for ddl. For this ,  is the below command sufficient for my requirement or do i need to have the 'exculde' parameter specifying all those that needs to be excluded.If anything else needs to be configured , please let me know .


      DDL INCLUDE MAPPED include optype 'alter'


      Thanks in advance.