Does the data migration process slow down dramatically when migrating tables that contain large volumes of binary data, such as images, binary data, or OLE objects?
Yes. This is a known problem in the data migration component of the Migration Workbench. You can create a data pump using JDBC/ODBC. The %ORACLE_HOME%/jdbc/demo directory contains a demonstration data pump. You can not use offline data loading for Sybase Adaptive Server and Microsoft SQL Server migrations because SQL*Loader cannot load binary data generated by BCP. Choose Object > Generate SQL*Loader Scripts from the Migration Workbench to use the offline data loading option.
Related Questions
- Does the data migration process slow down dramatically when migrating tables that contain large volumes of binary data, such as images, binary data, or OLE objects?
- May I apply CMP entity beans to process large amounts of data (like 20 million entities)? How is the performance of EJB CMP entity beans in this case?
- Which tables and columns in the schema contain the data found in the Population Diversity section of the refSNP Cluster Report?
