spool cr_repl_prebuilt.log /* Section 1 : Create the Snapshot Group */ connect mvadmin/******@REPL begin dbms_refresh.make( name=>'MVADMIN.TEST1', list=>'', next_date=>sysdate+5/(24*60), interval=>'sysdate+5/(24*60)', implicit_destroy=>TRUE, lax=>FALSE, job=>0, /* rollback_seg=>'RBS6', Use this if you want to use a particular RBS */ push_deferred_rpc=>FALSE, refresh_after_errors=>TRUE, purge_option=>NULL, parallelism=>NULL, heap_size=>NULL); end; / prompt Refresh Group Created... /* Section 2 : Create the Replication Group */ begin dbms_repcat.create_snapshot_repgroup( gname=>'TEST1', master=>'PROD', propagation_mode=>'ASYNCHRONOUS'); end; / prompt Master RepObject Created... /* Section 3 : Create the Snapshot */ connect ananda/******@REPL create snapshot TEST1 refresh fast as select * from ananda.TEST1@PROD / prompt Snapshot Created /* Section 4 : Add the Snapshot to the Group */ begin dbms_refresh.add( name=>'MVADMIN.TEST1', list=>'ANANDA.TEST1', lax=>TRUE); end; / prompt Snapshot added /* Section 5 : Generate Replication Support for the Snapshot */ connect mvadmin/******@REPL begin dbms_repcat.create_snapshot_repobject( gname=>'TEST1', sname=>'ANANDA', oname=>'TEST1', type=>'SNAPSHOT', min_communication=>TRUE); end; / prompt Snapshot RepObject Created spool off