To add subscriber tables to an Asynchronous Replication:

  1. Select the Replication node from the tree. A list of replications appears on the Replication page to the right.

  2. Select a replication from the list. The replication page will show subscriber information about the selected database in a table. Furthermore, the buttons Add Subscriber and Remove Subscriber will appear at the top of the page.

  3. Click Add Subscriber. The Select Destination Database wizard window will open.

  4. Select the destination database from the Database Session / Link Name menu. Click Next.

  5. JDBA will prompt you to log on to the destination database. Enter a User Name and Password for a user with DBA authority or SYSADM. Click OK, the Select Destination Columns window will open.

  6. The Select Destination Columns window will prompt you to select destination columns and a destination table.

  7. Select a destination table from the Table Name menu. A list of available columns on the selected table will appear on the left hand list box.

  8. Select destination columns by double clicking on the column name or selecting the column and clicking the add button. The add all button can be used to add all columns. All the selected destination columns will be displayed in the list box to the right. Columns can be likewise removed from the replication by double clicking on the column name or selecting the column and clicking the remove button.

    Note: The schema of the destination columns must match the schema of the source columns.

  9. Select Next after the desired columns have been selected.

  10. The Data Initialization window offers you two options. Select the desired options by checking the check box next to the appropriate option.

  11. Select Finish. The new database link will appear in the table on the Replication page.


Related topic:

Adding Subscribers to an Asynchronous Replication