Home » Server Options » Streams & AQ » Streams only for insert statement
Streams only for insert statement [message #267557] Thu, 13 September 2007 12:59 Go to next message
Messages: 120
Registered: November 2005
Senior Member
How do I configure streams to replicate only insert statements for a table. I know, how to do for DDl and DML

Re: Streams only for insert statement [message #267576 is a reply to message #267557] Thu, 13 September 2007 13:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68663
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you know for DDL and DML then you know for INSERT.
Isn't INSERT a DML? Very Happy

Seriously, add a handler to ignore all DML but INSERT.

Just a question, how do you handle duplicates in target? And why not apply UPDATEs?


Re: Streams only for insert statement [message #267896 is a reply to message #267557] Sun, 16 September 2007 03:14 Go to previous message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Previous Topic: synchronizing databases on windows and linux
Next Topic: SYS.AQ$_JMS_TEXT_MESSAGE type...how to look at values
Goto Forum:

Current Time: Tue Jun 18 20:39:01 CDT 2024