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


      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?