Hi. I have ran into couple of problems using Oracle workbench migration tool. I was wondering if anyone out there has any insight.
1. If a date field in a mysql table has a default (let's say 9999-12-31) the script for oracle table will also have 9999-12-31 as a default field. This doesn't seem to work in Oracle because Oracle expects to see something like to_date('9999-12-31','yyyy-mm-dd'). I couldn't find a way to modify that in the Workbench. 2. If a numeric field is defined in the mysql database as smallint, the workbench creates a corresponding Oracle field as num(250), while oracle would expect the presicion no more than 38. Again, I couldn't find a way to fix it in the workbench. 3. If I'm attempting to modify a oracle field's parameters in the workbench, it won't let me to move to another table without asking "do you want to save the changes" and won't move on unless I click on "No". I would appreciate any comments on these issues tia AOD __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php