Ad

Bulk Row Transfer Between Oracle Databases With A Select Filter

- 1 answer

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.

Ad

Answer

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;
Ad
source: stackoverflow.com
Ad