0 Replies Latest reply: Jul 11, 2012 9:47 AM by 939124 RSS

    Addition of new tables in existing golden gate DML replication setup

    939124
      We need to add new tables in existing list of tables to replicate

      Can some one please look below steps and tell if correct or no or I am missing anything ?

      Step 1
      Stop extract,datapump and replicate processes on source and target. Manager can be running on source and target.

      Step 2
      Add new tables in extract, datapump and replicate parameter files

      Step 3
      generate new DEFGEN file and move it from source to target

      Step 4

      Take export of new tables from source with current scn with expdp and import in destination database

      Step 5
      Restart all replication processes