Home » Server Options » Streams & AQ » replicating documents with Streams
replicating documents with Streams [message #148981] Tue, 29 November 2005 06:52
Messages: 4
Registered: November 2005
Location: Russia
Junior Member

I am using Oracle 10g ( and Streams technologies for replication. The question is about replicating such entities as documents (for example accounts, bills) with Oracle Streams.
Document consists of the master record in a master table, and one or more detail records in a detail table.

How can i keep a consistency in replicating documents?

For example, if one user adds an additional detail record in account in one base, and the second user does the same at the same time in the second base, then after capturing and applying changes we will have the equal but wrong documents in this databases - it will have 2 identical detail records instead of one.

How can i make Streams deal with the whole, entire document, not just 2 master-detail tables?

Thank you.
Previous Topic: Queue Monitor
Next Topic: problem with catpatch.sql
Goto Forum:

Current Time: Thu Mar 30 14:57:28 CDT 2023