I have 2 Sybase DB and 1 Oracle DB, I would like to replicate one of the tables in Sybase DB X (table name: customer_order) into my Sybase DB Y (table name: customer_order), and from the Sybase DB Y replicate into Oracle. The replication linking is like this:-
Sybase DB X --> Sybase DB Y --> Oracle
The replication from Sybase DB X to Sybase DB Y is working fine, but replication failed from Sybase DB Y to Oracle. When I tried to insert/delete/update some records on Sybase DB Y, it has been replicated to Oracle, but...when I tried to insert/delete/update some records on Sybase DB X, these transactions are able to replicate to Sybase DB Y, but it couldn't replicate into Oracle. WHY??
Appreciate if anyone could solve my doubts. Thanks a lot.
Replication Server version 15.7.1
Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 - 64bit Production
Adaptive Server Enterprise/15.5/EBF 19395 SMP ESD#5/P/Sun_svr4/OS 5.8/asear155/2568/64-bit/FBO/Fri Dec 9 09:16:52 2011