Does the Migration Workbench fully support the migration of LOB data using SQL*Loader scripts?
No. The Migration Workbench does not fully support the migration of LOB data using SQL*Loader scripts. The unload command dumps binary data as a series of hexadecimal characters. Within a SQL*Loader control file, you can apply the HEXTORAW SQL function to this field of hexadecimal character data to produce binary data. The Migration Workbench can then write binary data to a LONG RAW column. The Migration Workbench will generate a control file to do this automatically. You can use the Migration Workbench to generate the SQL*Loader control file for the table which stores binary data. To generate the SQL*Loader control file: After mapping the source database to the Oracle database with the Oracle Migration Workbench, navigate to the table in the Oracle Model, right-click on the icon for the table, and select Generate SQL*Loader Scripts. This generates the Informix Dynamic Server extraction script and the Oracle SQL*Loader script and control file for the table. In the SQL*Loader control fi
Related Questions
- Does the TimeTrends solution support periodic migration of data from existing data sources, with no manual intervention required?
- Does the Migration Workbench fully support the migration of LOB data using SQL*Loader scripts?
- Does the Migration Workbench support offline data loading in Microsoft Access?
