Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Recommendation for speeding up migration of Large tables from Oracle to PPAS via Migration Toolkit
In certain cases when a user wants to migrate large tables from his Oracle database to Advanced Server he might find the JDBC Copy method used by Migration Toolkit to be too slow.
Here user can opt to perform his migration over dblink_ora.
The dblink_ora module provides Advanced Server-to-Oracle connectivity at the SQL level.
dblink_ora is bundled and installed as part of the Advanced Server database installation. It utilizes the COPY API method to transfer data between databases. This method is considerably faster than the JDBC COPY method.
As a prerequisite for using this option the target Advanced Server database must have dblink_ora installed and configured.