Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Addition of new tables in existing golden gate DML replication setup

Paras Patel-OracleJul 12 2012 — edited Jul 13 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2012
Added on Jul 12 2012
3 comments
312 views