Oracle高级复制实施手记
gname => 'web_repg', master => 'web.simis', use_existing_objects =>
TRUE, copy_rows => FALSE, propagation_mode => 'ASYNCHRONOUS'); END;
/ -- 用以下查询确认是否加入该主体站点 SELECT DBLINK FROM DBA_REPSITES WHERE lower(GNAME) = 'web_repg'; prompt -- 创建 sidb 复制支持,默认 sname 为 sidb,必要需要修改 connect sidb/sidb@simis set heading off set pagesize 0 set linesize 800
spool add_sidb_rep_support.sql select 'exec DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (sname => ''sidb'',oname => '||''''||table_name||''''||',type => ''TABLE'',min_communication => TRUE);' from user_tables / spool off
connect repadmin/repadmin@simis @add_sidb_rep_support.sql prompt --
创建 bm 复制支持,默认 sname 为 bm,必要需要修改 connect bm/bm@simis set heading off set pagesize 0 set linesize 800
spool add_bm_rep_support.sql select 'exec DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (sname => ''bm'',oname => '||''''||table_name||''''||',type => ''TABLE'',min_communication => TRUE);' from user_tables / spool off