Oracle: transfer data between two database without db link

Question

I've got two database on different network. They can't see each other. So I can't use a Db Link.

Does toad or any other tool allow me to copy data from one db to the other one simulating a db link (it would be really simple simply executing a select on first DB and an insert on the second DB).

Anything solution for DataGrip or any JetBrains IDEA with Database connection support? — Eugene, Aug 30 '23 at 07:03

score 6 · Accepted Answer · answered Sep 05 '13 at 16:42

Toad can do it easily - instructions are for ver 11. First, connect to both databases using Toad. Then, find the table(s) in question in the Schema Browser. Right click on the table name, click 'Copy Data to Another Schema'. Choose the correct source/destination schemas, and set the options for the copy (triggers/constraints enable/disable, etc). Then click the green Play button and watch the records fly!

score 5 · Answer 2 · answered May 30 '12 at 14:20

5

If your workstation can see both databases simultaneously, you might be able to use the Database Copy tool in SQL Developer

SQL*PLus also has a Copy command.

answered May 30 '12 at 14:20

David Gelhar

27,873
3
67
84

score 2 · Answer 3 · answered Sep 17 '14 at 16:58

Toad or any other client is not a good solution for big tables, the client PC may fail or slow down, the network link may not be enough reliable, or the bandwith not enough. I would recommend Oracle Data Pump (expdp,impdp) in Oracle 10 onwards, or the former tools (exp/imp), sqlloader, etc. if we are talking of large environments.

score 1 · Answer 4 · answered May 30 '12 at 14:16

1

Dump a text file, FTP or move it, and then use SQL*Loader on the other side?

answered May 30 '12 at 14:16

bluevector

3,485
1
15
18

score 1 · Answer 5 · answered May 30 '12 at 14:19

1

Export from Source DB and then Import into Target DB

answered May 30 '12 at 14:19

Roger Cornejo

1,507
1
8
7

Oracle: transfer data between two database without db link

5 Answers5