Skip to Main Content

SQL & PL/SQL

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!

Question on Database link

SB35Jan 8 2022

Hello Experts, We have few databases with version 11.2 and few with recent 19C versions. I have a general question in regards to DB link.
We want to understand , If its good idea to use DB links and convert the simple ETL queries which runs across different databases (but are part of same workflow), into stored procedures which will fetch+move data using DB links within? Or will there be any performance overhead/security issues with DB links?

This post has been answered by Jonathan Lewis on Jan 9 2022
Jump to Answer
Comments
Post Details
Added on Jan 8 2022
6 comments
669 views