Oracle 数据库的集中复制方法浅议

disconnect; 
connect system/passwd@BJ; 
grant alter session to crm; 
grant create cluster to crm; 
grant create database link to crm; 
grant create sequence to crm; 
grant create session to crm; 
grant create synonym to crm; 
grant create table to crm; 
grant create view to crm; 
grant create procedure to crm; 
grant create trigger to crm; 
grant unlimited tablespace to crm; 
grant create type to crm; 
grant create any snapshot to crm; 
grant alter any snapshot to crm;

disconnect; 
connect SHORACL/SHORACL@BJ; 
create database link ORACLSH connect to ORACL identified 
by ORACL;

disconnect; 
connect mvadmin/mvadmin@BJ; 
create materialized view SHORACL.CREDIT_CARD refresh fast 
wit h pr imar y key as sele ct * from ORA CL. 
CREDIT_CARD@ORACLSH;

create materialized view SHORACL. CREDIT_CARD refresh 
fast with rowid as select * from ORACL. CREDIT_CARD@ORACLSH;

begin 
dbms_refresh.make ( 
name => ’mvadmin.sh_refresh’,list => ’’, 
next_date => sysdate,interval => ’sysdate + 1’, 
implicit_destroy => false,rollback_seg => ’’, 
push_deferred_rpc => true,refresh_after_errors => false); 
end;

begin 
dbms_refresh.add (name => ’mvadmin.sh_refresh’,list => ’SHORACL.CREDIT_CARD ’,lax => true); 
end; 
/

a) declare rc binary_integer; begin rc := sys.dbms_defer_sys. 
purge( delay_seconds=>0); end; 
b) declare rc binary_integer; begin rc := sys.dbms_defer_sys. 
push(destination=>’ORACLSH’, stop_on_error=>FALSE, 
delay_seconds=>0, parallelism=>0); end; 
c) dbms_refresh.refresh(’"MVADMIN"."SH_REFRESH"’);