MySQL Forums
Forum List  »  Oracle

Oracle to mySQL migration : Data truncation: Data too long for column
Posted by: Srini Raghavan
Date: April 09, 2007 01:36PM

Greetings ,

I am trying to migrate a table from Oracle 9.2 into MySQL 5.0.15 using Migration toolkit ver 1.1.11

I get the following error everytime :

Data truncation: Data too long for column 'comments' at row 266

If I save the file as a .sql file and upload it using the MySQL query browser - Open script - execute then it works.However this method cannot be applied to very large tables since the query browser window freezes.

However I do not understand why I am getting the error using the migration toolkit.The original datatype in oracle is varchar2(4000) and the corresponding datatype in mySQL is LONGTEXT.The maximum length of a value in the column is 195 , so the datatype LONGTEXT should be sufficient.

PLEASE HELP .

Srini

Options: ReplyQuote


Subject
Views
Written By
Posted
Oracle to mySQL migration : Data truncation: Data too long for column
3850
April 09, 2007 01:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.