Illustration strep039.htm shows an example of a Streams multiple-source replication environment. Each source/destination database includes:

• One or more ANYDATA queues

• Supplemental logging specifications

• Each shared object prepared for instantiation

• One or more capture processes

• One propagation for each of the other destination databases

• Instantiation SCN set for each shared object for each of the other source databases

• One apply process for each of the other source databases

• Rule sets for the capture process(es), propagation(s), and apply process(es)

• Conflict resolution if necessary

• A database link for each propagation