There are several similar Oracle tecnologies - Oracle Streams, Oracle Change Data Capture and Database Change Notification. Do you know what is difference between those? Are they related or Oracle Advanced Queueing? ...
I intend to use Oracle Streams for replication from Source to Target. The Target will be used mainly to run Reports. Earlier, all the reports used to run on the Source itself. Therefore, this arrangement gives better performance as all report queries are directed to a dedicated Target. I would also like to denormalize the tables on the...
I'm writing a workflow system that is driven entirely at each step by explicit human interaction. That is, a task is assigned to a person, that person selects from a few limited options {approve, reject, forward}, and then it is either sent along to the next person or terminated. Just curious if Oracle Streams/AQ has anything to offer ...
This question refers to the dequeueing of messages in Oracle Streams Advanced Queueing. I need to ensure that the messages which are related to each other are processed sequentially. For example, assume the queue is seeded with the four messages that have a business-related field called transaction reference (txn_ref) and two of the ...
Hi, I am just setting up a test project using Oracle Streams. My first problem is, is there something I need to install first? How can I tell if Oracle Streams is installed ? ...
I am just getting started with on a project and hope to use Oracle streams. I am looking for a straight-forward, hello-world type of example using Oracle Streams. Can you point me to a tutorial or show me an example? Thanks ...