This screenshot shows the Streams page that enables you to open the Setup Streams Replication Wizard in Oracle Enterprise Manager Cloud Control. At the top of the page are the Cancel and Continue buttons. Under the buttons is the text, "Oracle recommends that, prior to performing Streams Replication on databases in your configuration, you create a Streams Administrator user." The "Streams Administrator user" part is a link.

Under the text is the Setup Streams Replication option. This option includes the following sub-options:

• Replicate Whole Database

  Setup replication for whole database

• Replicate Schemas

  Setup replication for selected schemas by excluding desired tables

• Replicate Tablespaces

  Setup replication for a selected set of table spaces

• Replicate Tables

  Setup replication for selected tables and specifying the rules

Next is the Setup Downstream Capture option with the text, "Create downstream capture processes that can be used in replication by other databases."

Next is the Create Advanced Queue option with the text, "Create Advanced Queues that can be used by replication processes or any other processes."

Next is the Host Credentials section with the following text, "Operating System login credentials of the machine that runs the selected database." This section includes the Username and Password fields. Under these fields is a Save as Preferred Credential option.

On the right side of the page is an Overview section with the following text:

• Using the Streams Replication Setup wizard you can setup the streams replication between two databases.

• Replication can be setup for the Whole Database, selected table spaces, schemas or tables.

• It is possible to specify objects to exclude from replication.

• Downstream capture setup wizard helps to setup the capture and propagation processes on a different database from that of source database. These processes can be used in subsequent replication setup operations.

• You can edit the replication setup scripts to fix any issues or use any advanced data import export mechanism.

• You can create advanced queues, wizard helps to create the new queues for the messages that can be used by stream replication or any other processes.

• You can execute the setup processes immediately or schedule for later.

Copyright © 2003, 2015, Oracle and/or its affiliates. All rights reserved.