Skip to Main Content
  • Questions

  • Secure Network Data Transfer Between 2 Oracle Databases

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Shaun.

Asked: March 05, 2020 - 12:04 pm UTC

Last updated: March 05, 2020 - 2:45 pm UTC

Version: RDBMS 11.2 and up

Viewed 1000+ times

You Asked

Hi,

Historically we have file-based bulk data transfers using SFTP or SCP to migrate selected data to a bespoke data warehouse.

What I'd like to achieve is an automated transfer (pulled from the destination) encrypted across the network to avoid manual processes and bulk data files. I know Oracle has numerous mechanisms for transferring data, such as Data Pump (which we use). We've recently used Oracle Database Network Encryption to allow access to data across a database link but I wanted to check if there are better ways to achieve this? The target and destination databases will be differing versions but no earlier than 11.2

Thanks in advance

and Chris said...

Network-based data pump or using encrypted DB links are two of the simplest methods around.

Obviously depends on what exactly you're doing, but it sounds like you're already on the right track :)

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.