changing oracle DB link from Public to Private
913195Mar 8 2013 — edited Mar 8 2013Dear All,
I would like to know what will be the impact of chaning a PUBLIC db link to PRIVATE db link.
following is the scenario.
In our Prod distributed environment, there are many Databases which need to talk to each other for which we have create PUBLIC db links.
Similar PUBLIC DB links are also created in our DEV/ST/SIT/UAT environment...
Now we would like to know;
1. What will be impact (especially negative) if those DB link are converted to PRIVATE.
2. What are the disadvantages aer this PUBLIC to PRIVATE conversion...code espacially application users, code execution etc.
3. What are the considerations / steps to be taken to avoid any issues due to this PUBLIC to PRIVATE conversion.
Thanks and Regards
Santy.