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

Source Database

The source database includes:

• A SYS.AnyData queue
• Supplemental logging specifications
• A capture process
• One propagation for each destination database
• Rule sets for the capture process and the propagations
• Each shared object prepared for instantiation
• A database link to the destination database for propagation

Destination Database

The destination database includes:

• A SYS.AnyData queue
• Instantiation SCN set for each shared object
• An apply process for the source database
• Rule sets for the apply process

Additional Destination Databases

The environment may include additional destination databases.