OraFAQ Forum: Streams & AQ » Streams only for insert statement

Home » Server Options » Streams & AQ » Streams only for insert statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Streams only for insert statement [message #267557]

Thu, 13 September 2007 12:59

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 20:20:20 CST 2024