Migration Workbench loading TEXT to BLOB data from Informix 7.3 in incorrect order

We are trying to use Migration Workbench to migrate a Informix 7.3 DB to a Oracle 9.2.0.1.0 Server. We have been able to migrate all the tables successfully, with one exception: BYTE to BLOB fields. All the Informix tables that have BYTE columns are being migrated as BLOBs to Oracle (automatically mapped by workbench). Even though they are completely migrated (meaning that we can open the BLOB fields in Oracle and see the original word documents and tiff image files contained inside them), the migration is not keeping the order of the records: the image that should be associated with, for example, id_document=1 of a table is being migrated to another record of the table.
Long story short: all the BLOBs are being migrated, but completely out of order from their associated records.

Since there are tables with about 300k records, it is nearly impossible for us to search for an error pattern - for example, all BLOBs are being skipped by N from their original records. However, we suspect that WB is not dealing well with empty columns - maybe not skipping NULLs and assigning the next non-empty BLOB to the record with the NULL.

Can anyone help us with this problem?

Thanks a lot,

Luis Derani - DBA
Assembleia Legislativa - SP - Brazil
lderani_at_al.sp.gov.br Received on Fri Feb 07 2003 - 00:20:22 CET