Illustration strep039.htm shows an example of a Streams multiple source replication environment. The following sections describe the databases in this environment.

Source/Destination Database

The source/destination database includes:

• One or more SYS.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

Source/Destination Database

The source/destination database includes:

• One or more SYS.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

Additional Source/Destination Databases

The environment may include additional source/destination databases.