To
create an Asynchronous Table Replication:
Select Create from the top of the Replication page. The Create Replication window will appear.

Select Asynchronous Table Replication from the menu, the Create Asynchronous Table ReplicationWizard will begin.

Select Next. The Name the Replication window will appear.

The Asynchronous Table Replication Wizard will prompt you to identify the source table to replicate and name the replication. Select the source table from the Table Name menu at the bottom of the window. Enter a name into the Replication Name field and Click Next.

The Select Source Columns to be Replicated window will prompt you to select source columns from the source table. A list of available columns on the selected table appears on the left hand list box. Select source columns by double clicking on the column name or selecting the column and clicking add. The add all button can be used to add all columns to the replication. All the selected source 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 remove.
Click Next after the desired columns have been selected.

Note: You must select all primary key columns from the source table for replication.
The Where Clause window allows you to add a WHERE condition clause to the SQL script. This is useful if you want to place constraints on the data that is to be replicated. Click Next to continue.
Note: The WHERE clause must follow proper SQL syntax. Refer to the section on Constraint Syntax at the end of chapter 4 for more information.
The Asynchronous Table Replication Wizard will next prompt you to add destination columns to the replication.

Click Add at the bottom of the Select Destination Columns window. The Select Destination Database window will open.

You can choose to enter the destination database information manually or from the Database Session / Link Name menu at the bottom of the page. To enter the information manually, select the Enter Data Manually check box and provide the required information in the fields below.
Click Next.

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.

The Select Destination Columns window will prompt you to select destination columns and a destination table.
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.
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.
Click Next after the desired columns have been selected.

The Data Initialization window offers you three options. Select the desired options by checking the check box next to the appropriate option.
Clear Data: all data in the destination table is deleted when the replication is created.
Flush Data: copies all data that matches search criteria into the destination table.
No Cascade: prevents replicated data from being replicated from the destination tables. If this option is not selected, data can be replicated from the source database to the destination databases down to other databases that are subscribers to the destination databases.
Click Next. The Select Destination Columns window will reappear.

Click Add and repeat steps 7 – 13 if you want to add more columns, otherwise click Next.

Review the SQL script. You can edit the script manually by placing the cursor in the text field or click Previous to return to prior windows. Click Finish when you are satisfied with the SQL statement. The Information dialog box appears.

Click OK.
Related topic: