Oracle高級復(fù)制實(shí)施手記
gname => 'web_repg', master => 'web.simis', use_existing_objects =>
TRUE, copy_rows => FALSE, propagation_mode => 'ASYNCHRONOUS'); END;
/ -- 用以下查詢確認(rèn)是否加入該主體站點(diǎn) SELECT DBLINK FROM DBA_REPSITES WHERE lower(GNAME) = 'web_repg'; prompt -- 創(chuàng)建 sidb 復(fù)制支持,默認(rèn) 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 --
創(chuàng)建 bm 復(fù)制支持,默認(rèn) 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