Oracle Database Discussions

Hello All,

I am using the Migration Workbench (which I downloaded from Oracle a few months ago) to convert the database from SQL Server 2000 to Oracle 9.2 release. The problem is that for SQL Server 2000 VarChar over 4000, the migration tool makes the fields a CLOB.

We after the conversion, all the data which has been defined as VarChar 8000 data is present in Oracle as the CLOBS but are associated with the wrong record.

For example:

In the original SQL Server 2000 the database looks as below:

Primary Key FieldName1 (Varchar 8000) FieldName2 (VarChar 50)
101 Big Value 1 Small Value 1
102 Big Value 2 Small Value 2

In Oracle, after the migration, the table looks as below:

Primary Key FieldName1 (CLOB) FieldName2(VarChar 50)
101 Big Value 2 Small Value 1
102 Big Value 1 Small Value 2


Summary:
All the values are present but not in the correct place. As you can see, the values for 101 and 102 have been reversed for the CLOB data type but everything else is correct. I find this really troubling because it took me a few days to figure out why I was getting inconsistent result sets from my queries.

Does anyone know why the Migration Workbench is doing this? Does anyone have a solution so the migration will work correctly?