浅析Oracle数据库集中方法(1)(2)

disconnect;
connectsystem/passwd@BJ;
createusermvadminidentifiedby
mvadmin;
begin
dbms_repcat_admin.
grant_admin_any_schema(username=>’mvadmin’);
end;
/
grantcommentanytabletomvadmin;
grantlockanytabletomvadmin;
grantselectanydictionarytomvadmin;

begin
dbms_defer_sys.register_propagator(
username=>’mvadmin’);
end;
/

createpublicdatabaselinkORACLSHusing’oracle.shanghai.
com’;

createpublicdatabaselinkORACLSHusing’(description=
(address=(protocol=tcp)(host=127.0.0.1)(port=1521))
(connect_data=(service_name=oracl)))’

disconnect;
connectmvadmin/mvadmin@BJ;
begin
dbms_defer_sys.schedule_purge(
next_date=>sysdate,
interval=>’/*1:hr*/sysdate+1’,
delay_seconds=>0,
rollback_segment=>’’);
end;

createdatabaselinkORACLSHconnecttoproxy_bjoracle
identifiedbyproxy_bjoralce
Connectto...Identifiedby...子句指明用什么用户连接远程数据库

begin
dbms_defer_sys.schedule_push(
destination=>’ora92zjk’,interval=>’/*1:hr*/sysdate+1’,
next_date=>sysdate,stop_on_error=>false,
delay_seconds=>0,parallelism=>0);
end;
/

disconnect;
connectsystem/passwd@BJ;
grantaltersessiontocrm;
grantcreateclustertocrm;
grantcreatedatabaselinktocrm;
grantcreatesequencetocrm;
grantcreatesessiontocrm;
grantcreatesynonymtocrm;
grantcreatetabletocrm;
grantcreateviewtocrm;
grantcreateproceduretocrm;
grantcreatetriggertocrm;
grantunlimitedtablespacetocrm;
grantcreatetypetocrm;
grantcreateanysnapshottocrm;
grantalteranysnapshottocrm;

disconnect;
connectSHORACL/SHORACL@BJ;
createdatabaselinkORACLSHconnecttoORACLidentified
byORACL;

disconnect;
connectmvadmin/mvadmin@BJ;
creatematerializedviewSHORACL.CREDIT_CARDrefreshfast
withprimarykeyasselect*fromORACL.
CREDIT_CARD@ORACLSH;

creatematerializedviewSHORACL.CREDIT_CARDrefresh
fastwithrowidasselect*fromORACL.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;