Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

changing oracle DB link from Public to Private

913195Mar 8 2013 — edited Mar 8 2013
Dear 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2013
Added on Mar 8 2013
1 comment
884 views