Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate database
This example will show you the simplest way to implement replication
connect sys/change_on_install_at_2:v7n1
drop user repsys cascade;
create user repsys identified by repsys default tablespace usr;
grant connect, resource to repsys;
execute dbms_repcat_auth.grant_surrogate_repcat('repsys');
drop user repadmin cascade;
create user repadmin identified by repadmin default tablespace usr;
grant connect,resource to repadmin;
execute dbms_repcat_admin.grant_admin_any_repgroup(userid=>'repadmin');
drop user repuser cascade;
create user repuser identified by repuser default tablespace usr;
grant connect, resource to repuser;
execute dbms_repcat_admin.grant_admin_repgroup(userid=>'repuser');
grant execute on dbms_defer to repuser;
connect sys/change_on_install_at_2:v7n2
drop user repsys cascade;
create user repsys identified by repsys default tablespace usr;
grant connect, resource to repsys;
execute dbms_repcat_auth.grant_surrogate_repcat('repsys');
drop user repadmin cascade;
create user repadmin identified by repadmin default tablespace usr;
grant connect,resource to repadmin;
execute dbms_repcat_admin.grant_admin_any_repgroup(userid=>'repadmin');
grant execute on dbms_defer to repuser;
connect repadmin/repadmin_at_2:v7n1
execute dbms_repcat.drop_master_repgroup('REPUSER',TRUE,TRUE);
connect sys/change_on_install_at_2:v7n1
create table repuser.dept as select * from scott.dept;
alter table repuser.dept add primary key (deptno);
connect repadmin/repadmin_at_2:v7n1
execute dbms_repcat.create_master_repgroup('GROUP1');
execute
dbms_repcat.create_master_repobject('REPUSER','DEPT','TABLE',gname=>'GROUP1'
);
execute dbms_repcat.generate_replication_support('REPUSER','DEPT','TABLE');
connect repuser/repuser_at_2:v7n1;
create snapshot log on dept;
connect repadmin/repadmin_at_2:v7n2;
create database link gnv7n1.world
connect to repadmin identified by repadmin using '2:v7n1';
connect repuser/repuser_at_2:v7n2
create database link gnv7n1.world
connect to repuser identified by repuser using '2:v7n1';
execute dbms_repcat.drop_snapshot_repgroup('GROUP1',TRUE);
execute dbms_repcat.create_snapshot_repgroup('GROUP1','gnv7n1.world');
execute
dbms_repcat.create_snapshot_repobject('repuser','DEPT','SNAPSHOT','create
snapshot dept refresh fast start with sysdate next sysdate+(1/2880) for
update as select * from dept_at_gnv7n1.world',gname=>'GROUP1');
connect repadmin/repadmin_at_2:V7N1
execute DBMS_REPCAT.RESUME_MASTER_ACTIVITY('GROUP1',true);
connect repuser/repuser_at_2:v7n2
insert into dept values(50,'ADMIN','LONDON');
commit;
connect repadmin/repadmin_at_2:v7n2
execute DBMS_DEFER_SYS.EXECUTE('gnv7n1.world');
connect repuser/repuser_at_2:v7n1
select * from dept;
connect repuser/repuser_at_2:v7n1
insert into dept values(60,'SUPPORT','ORLANDO');
commit;
connect repuser/repuser_at_2:v7n2
execute dbms_snapshot.refresh('repuser.dept','?');
select * from dept;
mariusdb_at_my-dejanews.com wrote in message <70jp1s$hn7$1_at_nnrp1.dejanews.com>...
>A client of mine are running Oracle 7.3.3 on Sun Solaris They would like to >keep an duplicate up-to-date copy of a subset of the data from a production >database. The copy will run on a separate machine. They would like the copy >to be kept up-to-date (real time) with data updates made to the original >database (but not the other way around) > >How would I go about doing something like this?? > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I&
M3CI987-S:7(@2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1%
M3#M(3TU%.U9/24-%.BLT-"@P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE#
M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I,
M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP
M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O
M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM)
M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ
<.3DX,3 S,50R,#(R,3A:#0I%3D0Z5D-!4D0-"@``
`
end
Received on Sat Oct 31 1998 - 14:22:19 CST