Oracle: transfer data between two database without db link

oracle toad
Revious picture Revious · May 30, 2012 · Viewed 16.8k times · Source

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).

Answer

Jeremy Scoggins picture Jeremy Scoggins · Sep 5, 2013

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!

Related questions

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on having this error? I …

Read More
How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, DATE_UPD, CREATOR, CENTER, ETAT, REQUEST) VALUES('555-vgd9-pllkd-5513', '172.12.23.130', 'N', SYSDATE, SYSDATE, '1554', …

Read More
SQL query for extracting year from a date

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YEAR function can be …

Read More