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 .