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.
Bulk Row Transfer between Oracle Databases with a Select Filter
By : Jacob
You may not even need to move that data. Maybe you can just select across the database link.
By : David Aldridge
This video can help you solving your question :)