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
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: 68624
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

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
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: Thu Mar 28 09:59:51 CDT 2024