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

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 Go to previous message
Frank Naude
Messages: 4379
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 22 04:16:19 CDT 2013

Total time taken to generate the page: 2.38164 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.