Using Java Copy data from one oracle Database table to another database table
I want to copy a table from one oracle database to another using Java. (JDBC APIs) the two databases are disconnected from each other (i.e. they do not have any DBlinks pointing to each other).
Can someone specify the most efficient开发者_运维技巧 way to do this.
These tables will be having anywhere between 30,000 to 50,000 rows with 10 columns
open a connection to database 1 open another connection to database 2 read from database 1 into java structures write into database 2 from java structures.
or use an available off the shelf utility.
精彩评论