This discussion is archived
1 Reply Latest reply: Nov 22, 2012 10:01 PM by 862209 RSS

Streams Target Table adding column with default value

862209 Newbie
Currently Being Moderated
Hi

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 .

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points