As of now, we are using Oracle COMPLETE refresh method Materialized View which is refreshing 40 million records everyday through dB-link tables of remote database.
But remote database team is complaining as it is impacting their database and suggesting us to use oracle golden gate ( GG ) method to pull data.
I'm thinking of using FAST MV refresh method instead of Oracle Golden Gate as it would quicker to implement.
Can anyone tell me if FAST MV refresh is as good as golden gate approach ? What are pros and cons of both ways ?
Regards, Pravin