Migration - MySQL to Oracle - not generating data files
883763Aug 22 2011 — edited Aug 23 2011Hi,
I have been using the SQL Developer migration wizard to move data from a MySQL 5 database to an Oracle 11g database.
I've used it sucessfully a couple of times and its all worked fine.
However, i'm currently having a problem whereby there are no offline data files generated. The control files and all other scripts are generated fine...just no data files.
This has worked fine before so I am a bit stumped as to why its no logner working.
I have looked at the migration logs information and there are no errors shown - datamove is marked as success.
I have tried dropping and re-creating rhe migration repository and checked all the grants and privs.
If there was an error message then there would be something to go on but have tried several times and checked everything I can think of.
I've also tried the migration command line approach....same thing. All runs fine...no errors...but only the table creation and control file scripts are generated.
The source schema is very simple and there are only tables to migrate..no procedures or anything else.
Can anyone suggest anything?
Many thanks,
Mike