Idea Details:
Every time we add new table or schema to Extract, Pump or Replicate we need to bounce Extract and replicate by halting current running transactions.
To Avoid, halting current running transactions and performing manual stopping and starting Extract and replicates, with this idea expecting a simple way to auto refresh currently running Extract and replicates parameters.
Reported release:
Currently Using Golden gate 12.1.0 (both Classic & Integrated , Capture and Delivery)
Business process:
Automatic refresh of Extract(s) and replicat(s) parameters.
Gap and benefits:
Manually Stopping and starting Extract(s) and Replicate(s).
Do not need to stop current running transactions and auto refreshes existing Extract(s) and Replicate(s).
Refresh Goldengate Extract, Pump, Replicat without Stop & Start just like refresh Manager.
Eg:
GGSCI> REFRESH MGR
GGSCI> REFRESH EXTRACT <EXTRACT GROUP>
GGSCI> REFRESH REPLICAT <REPLICAT GROUP>
Thanks
Phani Krishna Gurrala