I need to have another DB in our intranet env which gather Statistics from Our PROD Database in anotherbox. PROD is very heavy OLTP type. What's is the best stretegy ? Can I use DB link to load the primary data or I can do it only with exp and imp.
Printable View
I need to have another DB in our intranet env which gather Statistics from Our PROD Database in anotherbox. PROD is very heavy OLTP type. What's is the best stretegy ? Can I use DB link to load the primary data or I can do it only with exp and imp.
You should be able to do this either way.
Looks Like intranet or heavy transaction load doesn't let DB LINK works properly. Is that the case. Any similaR SITUATION happens for you guys??