dblinks to cloud instance
From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Thu, 15 Jul 2021 07:45:52 -0700
Message-ID: <CAKsxbLrq-N1qLiwf9NtSS6eD4N+e_XecZermbymuaKtPTvwf7Q_at_mail.gmail.com>
What is your opinion on joining to a table over a database link that resides in the cloud and your local database is on prem? And what if this cloud instance is MSSQL and your local is Oracle? We have something in the works that I just found out is supposed to go to production next week. They are joining local and remote tables together. So far in testing things are looking ok but the amount of data is limited right now, I am unsure how much it will grow to. Wondering if anyone has any experience with this.
Date: Thu, 15 Jul 2021 07:45:52 -0700
Message-ID: <CAKsxbLrq-N1qLiwf9NtSS6eD4N+e_XecZermbymuaKtPTvwf7Q_at_mail.gmail.com>
What is your opinion on joining to a table over a database link that resides in the cloud and your local database is on prem? And what if this cloud instance is MSSQL and your local is Oracle? We have something in the works that I just found out is supposed to go to production next week. They are joining local and remote tables together. So far in testing things are looking ok but the amount of data is limited right now, I am unsure how much it will grow to. Wondering if anyone has any experience with this.
Thanks,
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 15 2021 - 16:45:52 CEST