1 Reply Latest reply: Jun 18, 2013 2:46 PM by gottikere RSS

    Stream Replication: How to use One LCR to update 2 tables in same destination instance

    1011226

      Hi there,

       

      I have 2 instances: srcinstance and dstinstance,

       

      source instance:

      SID: srcinstance

      Schema: SCOTT

      Table: EMP

       

      destination instance:

      SID: dstinstance

      Schema: SCOTT

      Table: EMP, EMPNEW

       

      Tables of EMP are identical, EMPNEW is copied from EMP and modified, now, I need replicate DML changes into EMP and EMPNEW. any advice?

       

      Thanks,

       

      Arthur