Bulk Row Transfer between Oracle Databases with a Select Filter

By : Jacob
Source: Stackoverflow.com
Question!

Basically, I'm trying to selectively copy a table from one database to another. I have two different [Oracle] databases (e.g., running on different hosts) with the same schema. I'm interested in a efficient way to load Table A in DB1 with the result of running a select on Table A in DB2. I'm using JDBC, if that's relevant.

By : Jacob


Answers

You may not even need to move that data. Maybe you can just select across the database link.



Use a database link, and use create table as select.

create database link other_db connect to remote_user identified by remote_passwd using remote_tnsname;

create table a as select * from [email protected]_db;


This video can help you solving your question :)
By: admin