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
toshidas2000
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

Thanks

Report message to a moderator

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: 54129
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?

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 10:20:58 CDT 2013

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