Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate database

Re: Duplicate database

From: Yassir Khogaly <yassir_at_khogaly.freeserve.co.uk>
Date: Sat, 31 Oct 1998 20:22:19 -0000
Message-ID: <71frig$ibs$1@newsreader1.core.theplanet.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US