GoldenGate
835066Jan 28 2011 — edited May 9 2011I'm having trouble with goldengate...
I'm trying to replicate a table from linux named source to linux named target.
I have exact same tables in both databases.Only difference is source has 5 entries
ORDER_ID ORDER_NAME
---------- ----------
1 test
2 test2
5 test5
3 test3
4 test4
while the target has 2 entries.
ORDER_ID ORDER_NAME
---------- ----------
1 test
2 test2
.
When i run my Extract ext1 from source and Replicat rep1 from target i got no errors,both work fine.
But when i check the logs of ext1 and rep1 they all say No Records Extracted._
And there is nothing replicated to orders table in target from orders table in source.
my params for ext1 Extract from source
EXTRACT ext1
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST target, MGRPORT 7809
RMTTRAIL /u01/app/oracle/product/ggs/dirdat/rt
TABLE orders;
my params for rep1 Replicat from target
REPLICAT rep1
ASSUMETARGETDEFS
USERID ggs_owner, PASSWORD ggs_owner
MAP orders, TARGET orders;
How can i solve this problem ?
Since there is no errors I Dont get why it's not replicating orders table from source to target.
Thanks.