Home » Server Options » Streams & AQ » Streams - capturing and propagating only inserts on table
Streams - capturing and propagating only inserts on table [message #75709] Wed, 02 June 2004 14:05 Go to next message
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
Re: Streams - capturing and propagating only inserts on table [message #75718 is a reply to message #75709] Wed, 23 June 2004 05:54 Go to previous message
Frank Naude
Messages: 4420
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
Previous Topic: replication error - LCR contains a column of unsupported type
Next Topic: Removing Bad Queue Table
Goto Forum:
  


Current Time: Sat Dec 20 00:47:01 CST 2014

Total time taken to generate the page: 0.12434 seconds