OraFAQ Forum: Streams & AQ » Streams - capturing and propagating only inserts on table

Home » Server Options » Streams & AQ » Streams - capturing and propagating only inserts on table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Streams - capturing and propagating only inserts on table [message #75709]

Wed, 02 June 2004 14:05

Kelly Goodrich
Messages: 3
Registered: November 2002

Junior Member

Does anyone know how to set up the rules to capture only inserts on a table or handling them at the propagation level?

Thanks

Kelly Thomas

kgoodrich@fgm.com

Report message to a moderator

Re: Streams - capturing and propagating only inserts on table [message #75718 is a reply to message #75709]

Wed, 23 June 2004 05:54

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

You need to alter your capture or propagation rules and include:

AND :dml.get_command_type() IN ('INSERT')

There is an example in Chapter 6 "How Rules Are Used In Streams" of the "Oracle9i Streams Release 2 (9.2)" manual.

Best regards.

Frank

Report message to a moderator

Previous Topic:	replication error - LCR contains a column of unsupported type
Next Topic:	Removing Bad Queue Table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 06:56:05 CST 2025