Home » Server Options » Streams & AQ » AQ or Streams (10g R2)
AQ or Streams [message #504310] Sat, 23 April 2011 08:02 Go to next message
GSREDDY
Messages: 13
Registered: October 2005
Location: Hyderabad
Junior Member
We have a requirement like whenever user does some operation on a table(insert/update/delete), it should replicate the same into some another tables based on some application functionality. Sometimes it can be 100 records and sometimes it will be some million records(I think triggers is a bad idea). Here all tables will be in the same schema and user is a single user for our testing and at client site there will be some 100-250 users.

Which option you suggest to achieve this, Streams or Advanced Queues?
Re: AQ or Streams [message #504313 is a reply to message #504310] Sat, 23 April 2011 09:02 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the difference between Streams and AQ?

Regards
Michel
Previous Topic: Why can't I enqueue a message with String attributes?
Next Topic: Asynchronous Auto Change Data Capture - Data Recovery from REDO Log files
Goto Forum:
  


Current Time: Fri Mar 29 00:44:43 CDT 2024