1 Reply Latest reply on Nov 23, 2012 6:01 AM by 862209

    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 .