oracle创建用户Oracle高级复制的创建配置

1、oracle创建用户:Oracle高级复制的创建配置 步骤-Step by Step疯狂代码 http:/CrazyC :http:/CrazyC本例涉及两个站点.注:主体定义站点指配置复制工作站点本例涉及用户.复制治理员:repadmin应用用户:hawa本例复制对象:hw_test 数据表1.在主体定义站点复制用户下创建复制对象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.在主体站点同样创建复制对象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.在主体站点手工同步数据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.在主体定义站点删除数据测试: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