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!

Please help in understanding DB Link scenario

Rajneesh S-OracleJun 29 2019 — edited Feb 21 2020

Hi All,

I need to know how data moves through DB Link:

Scenario 1:

Suppose I have 2 database instances- 2 different PDBs (Pluggable databases) in same Database (same CDB- Container database).

If I will use DB link between 2 PDBs to transfer data from one database instance to another database instance, then weather my data is exposed over network?

Or it is being transferred without getting exposed to network as both instances are hosted by same server.

Scenario 2:

What about if source and target data bases are hosted on 2 different servers , then db link transfer will expose data to netowrk?

How about sql loader etc...is it exposing data to network when transering data from source db to tareget.

Thanks,

Rajneesh

This post has been answered by Zlatko Sirotic on Jun 29 2019
Jump to Answer
Comments
Post Details
Added on Jun 29 2019
2 comments
290 views