开发者

Using Java Copy data from one oracle Database table to another database table

开发者 https://www.devze.com 2023-03-24 01:56 出处:网络
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).

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

精彩评论

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

关注公众号