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

1、oracle創(chuàng)建用戶:Oracle高級復制的創(chuàng)建配置 步驟-Step by Step瘋狂代碼 http:/CrazyC :http:/CrazyC本例涉及兩個站點.注:主體定義站點指配置復制工作站點本例涉及用戶.復制治理員:repadmin應(yīng)用用戶:hawa本例復制對象:hw_test 數(shù)據(jù)表1.在主體定義站點復制用戶下創(chuàng)建復制對象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.在主體站點同樣創(chuàng)建復制對象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.在主體站點手工同步數(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.在主體定義站點開始操作登陸主體定義站點$ sqlplus repadmin/passwordSNAMEONAMES

4、TATUS GNAME - - - - HAWA HW_TESTVALIDREP_HH HAWA HW_TEST$RP VALIDREP_HH HAWA HW_TEST$RP VALIDREP_HH在主體定義站點啟動復制:SQL> select * from global_name;GLOBAL_NAME-SQL> execute dbms_repcat.resume_master_activity('rep_hh',true;PL/SQL procedure successfully completed.在主體定義站點刪除數(shù)據(jù)測試: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在主體站點觀察變化:SQL> select * from global_name;GLOBAL_NAMESQL> selec