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