Re: Data access from one dB to other

Posted by ErmanArslansOracleBlog on Jun 07, 2021; 1:29pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Data-access-from-one-dB-to-other-tp9856p9858.html

Yes, you can use db links, web services, some code that have the access drivers for those databases like jdbc, also you can have a replication tool that replicates data from one db to another, a CDC application, a fast and atomic ETL and so on.. you name it..

But db link is the old fashion.. I don't recommend using them for critical and long processes.. The errors on the dblink layer is not catchable most of the time.. Consider a modern approach..