Illustration strep040.htm shows an example of adding a destination database to an existing Streams single source replication environment. The following sections describe the databases in this environment.

Source Database

Additional configuration includes:

• Each shared object prepared for instantiation
• A propagation for the added destination database
• Added database link for added propagation

Also, the source database has existing database links for existing propagations.

Added Destination Database

Additional configuration 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

Existing Destination Database

No additional configuration is required.

Additional Destination Databases

The environment may include additional destination databases.