This discussion is archived
1 Reply Latest reply: Apr 24, 2013 11:05 PM by Rc-oracle RSS

capture the changes but apply them in $urvivor series

974829 Newbie
Currently Being Moderated
We planning to replicate tables in one schema(A) with another schema(B) in the same database.

I would like to know, once we start the capture process using dbms_capture_adm.start_capture is it possible to wait for 3hrs until all the tables in source schema (A) DML's finishes, and then only start apply process?

Basically we need to capture the changes but apply them in the destination later time?

Also would this consume more space in streams admin schema or any where else? Because the changes will bring 2- 3GB worth of table data




Edited by: 971826 on Nov 18, 2012 2:37 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points