<p>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.</p>

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 a@other_db;
```
```