Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Table migration from SQL Server 2019 to Oracle 19c using dblinks

User_7OO0XSep 13 2022

I need to migrate multiple tables from SQL Server 2019 into Oracle 19C. Currently I am using dblink connection from SQL Server and it can Migrate about 125K row per minute which is too long for me. Right now, I am using SELECT from SQL Server then INSERT into Oracle inside a procedure. I need a faster query or a query that can commit every 1 million rows so that the query can be inserted even the query is stuck. Thanks

Added on Sep 13 2022

#database-connectivity-discussions

0 comments

352 views