I'm having a problem when migrating data form MySQL to Oracle-11g using Migration Tool of SQLDeveloper 22.214.171.124.
The problem is related with the format of default date fields. Checking the .out files after the migration I have found this error :
Error que empieza en la línea 176 del comando: CREATE TABLE comentario ( id NUMBER(10,0) NOT NULL, texto VARCHAR2(128 CHAR), inicio DATE DEFAULT to_date('01-JAN-70 00:00:00', 'dd-MON-yy hh24:mi:ss') NOT NULL
+)+ Error en la línea de comandos:179 Columna:30 Informe de error: Error SQL: ORA-01843: mes no válido
+01843. 00000 - "not a valid month"+
I think that the problem is that the destination databases have been installed in spanish, but the month of the default date is in english. Is it possible to change the format of the default date?
I've manually modify the sql file associated with the migration project to replace 01-JAN-70 with 01-ENE-70 and the problem has been solved, so I'm pretty sure that the problem is this, but I don't know if it's possible to configure the migration tool to use a different format or date for the default date.
It might be possible within the tool prior to creating the converted model.
In the online help within SQL*Developer, take a look under migrating 3rd party databases - Creating and Customizing the Converted Model.
It states there:
"To convert a captured model to a converted model, right-click the appropriate node in the Captured Models navigator and select Convert to Oracle, and specify or accept the defaults for data mappings."
You might be able to modify the default date setting at this point.