----------  Create or Drop Replication  ----------

The "create replication master" command creates replication master entry
(master-replicate relationship) in sys_rep_masters.

Syntax:

     create replication master REPLICATION_MASTER_INFO on REPLICATION_TABLE
                [with force];

REPLICATION_MASTER_INFO is one of the form:  

    a)  SERVER_NAME:DB_NAME:TABLE_NAME

    b)  SERVER_NAME:DB_NAME..TABLE_NAME

REPLICATION_TABLE can be master or replicate table.

If "with force" option is specified, the existence of corresponding replication
replicate entry on master side is not checked. 

The "create replication replicate" command creates replication replicate entry
in sys_rep_replicates. It authorizes a table to be a candidate replication
replicate table. 

Syntax:

     create replication replicate REPLICATION_REPLICATE_INFO 
               on REPLICATION_TABLE [where WHERE_CLAUSE];

REPLICATION_REPLICATE_INFO is one of the form:  

    a)  HOST_NAME:DB_NAME:TABLE_NAME

    b)  HOST_NAME:DB_NAME..TABLE_NAME

"where" option just works for master/replicate tables which support subset
replication, and WHERE_CLAUSE can be a simple boolean expression where
no explicit database and table references is allowed. 

For further information on create replicate table, enter:

               help cr_table;


To REMOVE a replication master entry of a replication table from
sys_rep_masters, the "drop replication master" command is used.

Syntax:

     drop replication master REPLICATION_MASTER_INFO on REPLICATION_TABLE
              [with force];

To REMOVE all replication master entries of a replication table from
sys_rep_masters, the "drop all replication masters" command is used.

Syntax:

     drop all replication | masters | on REPLICATION_TABLE [with force];
                          | master  |

To REMOVE a replication replicate entry of a replication table from
sys_rep_replicates, the "drop replication replicate" command is used.

Syntax:

     drop replication replicate REPLICATION_REPLICATE_INFO 
               on REPLICATION_TABLE;

To REMOVE all replication replicate entries of a replication  table from
sys_rep_replicates, the "drop all replication replicates" command is used.

Syntax:

     drop all replication | replicates | on REPLICATION_TABLE;
                          | replicate  |
