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.