oracle创建用户Oracle高级复制的创建配置_百度文库.doc

一课资料网/oracle创建用户:Oracle高级复制的创建配置 步骤-Step by Step疯狂代码 http:/CrazyC/ :http:/CrazyC/DataBase/Article46137.html本例涉及两个站点.主体定义站点:AVATAR.COOLYOUNG.COM.CN主体站点:AUTHAA.COOLYOUNG.COM.CN注:主体定义站点指配置复制工作站点本例涉及用户.复制治理员:repadmin应用用户:hawa本例复制对象:hw_test 数据表1.在主体定义站点复制用户下创建复制对象SQL select * from global_name;GLOBAL_NAME-AVATAR.COOLYOUNG.COM.CNSQL connect hawa/passWordConnected.SQL create table hw_test as select * from hw_online;Table created.SQLselect count(* from hw_test;COUNT(*- 464SQL alter table hw_test add (constra pk_userid primary key (numuserid; Table altered.2.在主体站点同样创建复制对象SQL select * from global_name;GLOBAL_NAME-AUTHAA.COOLYOUNG.COM.CNSQL connect hawa/passwordConnected.SQL create table hw_test as select * from hw_online;Table created.SQL select count(* from hw_test;COUNT(*- 03.在主体站点手工同步数据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/passwordSQL*Plus: Release .0 - ProdUCtion _disibledevent=REP_HH;SNAMEONAMESTATUS GNAME - - - - HAWA HW_TESTVALIDREP_HH HAWA HW_TEST$RP VALIDREP_HH HAWA HW_TEST$RP VALIDREP_HH在主体定义站点启动复制:SQL select * from global_name;GLOBAL_NAME-AVATAR.COOLYOUNG.COM.CNSQL execute dbms_repcat.resume_master_activity(rep_hh,true;PL/SQL procedure successfully completed.在主体定义站点删除数据测试:SQL connect hawa/passwordConnected.SQL select count(* from hw_test;COUNT(*- 464SQL delete from hw_test where rownum commit;Commit complete.SQL select count(* from hw_test;COUNT(*- 445在主体站点观察变化:SQL select * from global_name;GLOBAL_NAME- AUTHAA.COOLYOUNG.COM.CNSQL select