开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜