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

"create replication master" ޥɤ sys_rep_masters ơ֥˥֥ꥱ
ޥȥ(ޥ֥ꥱȴطˤޤ

󥿥å:

     create replication master REPLICATION_MASTER_INFO on REPLICATION_TABLE
                [with force];

REPLICATION_MASTER_INFO ϰʲη:

    a)  SERVER_NAME:DB_NAME:TABLE_NAME

    b)  SERVER_NAME:DB_NAME..TABLE_NAME

REPLICATION_TABLE ϥޥơ֥ϥ֥ꥱȥơ֥ɤǤ⹽


⤷ "with force" ץ󤬻ȤƤʤ顢ϢƤ֥ꥱ
ΥޥɤΥ֥ꥱȥȥåޤ

"create replication replicate" ޥɤ sys_rep_replicates ơ֥˥֥
֥ꥱȥȥޤϥǥǥȥ֥ꥱ
֥ꥱȥơ֥Ĥޤ

󥿥å:

     create replication replicate REPLICATION_REPLICATE_INFO
               on REPLICATION_TABLE [where WHERE_CLAUSE];

REPLICATION_REPLICATE_INFO ϰʲη:

    a)  HOST_NAME:DB_NAME:TABLE_NAME

    b)  HOST_NAME:DB_NAME..TABLE_NAME

"where" ץϥ֥åȥ֥ꥱ򥵥ݡȤƤޥ/
ꥱݥȥơ֥˻Ȥޤ WHERE_CLAUSE ϥץǤ⹽ޤ

create replicate table ξ˴ؤ, ʲϤƲ:

               help cr_table;


sys_rep_masters ơ֥Υ֥ꥱޥȥˤϡ
"drop replication master" ޥɤѤ뤳ȤǤޤ

󥿥å:

     drop replication master REPLICATION_MASTER_INFO on REPLICATION_TABLE
              [with force];

sys_rep_masters ơ֥Τ٤ƤΥ֥ꥱޥȥ
ˤϡ"drop all replication masters" ޥɤѤ뤳ȤǤޤ

󥿥å:

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

sys_rep_replicates ơ֥Υ֥ꥱ֥ꥱȥȥ
ˤϡ"drop replication replicate" ޥɤѤ뤳ȤǤޤ

󥿥å:

     drop replication replicate REPLICATION_REPLICATE_INFO
               on REPLICATION_TABLE;

sys_rep_replicates ơ֥Τ٤ƤΥץꥱץꥱݥȥȥ
ˤϡ"drop all replication replicates" Ѥ뤳ȤǤޤ

󥿥å:

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