1 Reply Latest reply: Nov 23, 2012 12:01 AM by 862209 RSS

    Streams Target Table adding column with default value


      I configured streams between Oracle 11.2.03 (source and target) using dbms_streams_adm.maintain_tables procedure.

      ON the target table , i added a column with the default value as sysdate . The replication works fine but the column default value is not populated whenever a new row is inserted in the source . Also , i want a create a trigger on target table for insert/update/delete.

      Appreciate suggestions .