STREAMS Apply not firing trigger consistently
edited Feb 17, 2010 10:19PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hi, Noob here.
On 10.2.0.4 Enterprise edition, Solaris SPARC platform, I am having an issue with Streams behavior.
The target table of an apply process has an "AFTER EACH ROW" insert trigger. When streams applies changes to the table, the trigger does not fire for every row; however, all changes are applied to the table without error. The trigger inserts rows into another table that performs a rollup of the data.
Has anyone encountered this before?
Thanks!
0