oracle創(chuàng)建用戶Oracle高級(jí)復(fù)制的創(chuàng)建配置

1、oracle創(chuàng)建用戶:Oracle高級(jí)復(fù)制的創(chuàng)建配置 步驟-Step by Step瘋狂代碼 http:/CrazyC :http:/CrazyC本例涉及兩個(gè)站點(diǎn).注:主體定義站點(diǎn)指配置復(fù)制工作站點(diǎn)本例涉及用戶.復(fù)制治理員:repadmin應(yīng)用用戶:hawa本例復(fù)制對(duì)象:hw_test 數(shù)據(jù)表1.在主體定義站點(diǎn)復(fù)制用戶下創(chuàng)建復(fù)制對(duì)象SQL> select * from global_name;GLOBAL_NAME-SQL> connect hawa/passWordConnected.SQL> create table hw_test as select * from hw

2、_online;Table created.SQL>select count(* from hw_test;COUNT(*- 464SQL> alter table hw_test add (constra pk_userid primary key (numuserid; Table altered.2.在主體站點(diǎn)同樣創(chuàng)建復(fù)制對(duì)象SQL> select * from global_name;GLOBAL_NAME-SQL> connect hawa/passwordConnected.SQL> create table hw_test as select * f

3、rom hw_online;Table created.SQL> select count(* from hw_test;COUNT(*- 03.在主體站點(diǎn)手工同步數(shù)據(jù)SQL> connect repadmin/passwordConnected.SQL> insert o hawa.hw_test select * from hawa.hw_testavatar;464 rows created.SQL> commit;Commit complete.4.在主體定義站點(diǎn)開(kāi)始操作登陸主體定義站點(diǎn)$ sqlplus repadmin/passwordSNAMEONAMES

4、TATUS GNAME - - - - HAWA HW_TESTVALIDREP_HH HAWA HW_TEST$RP VALIDREP_HH HAWA HW_TEST$RP VALIDREP_HH在主體定義站點(diǎn)啟動(dòng)復(fù)制:SQL> select * from global_name;GLOBAL_NAME-SQL> execute dbms_repcat.resume_master_activity('rep_hh',true;PL/SQL procedure successfully completed.在主體定義站點(diǎn)刪除數(shù)據(jù)測(cè)試:SQL> connect hawa/passwordConnected.SQL> select count(* from hw_test;COUNT(*- 464SQL> delete from hw_test where rownum <20;19 rows deleted.SQL> commit;Commit complete.SQL> select count(* from hw_test;COUNT(*- 445在主體站點(diǎn)觀察變化:SQL> select * from global_name;GLOBAL_NAMESQL> selec