Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migration - MySQL to Oracle - not generating data files

883763Aug 22 2011 — edited Aug 23 2011
Hi,

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
This post has been answered by Dermot ONeill-Oracle on Aug 22 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2011
Added on Aug 22 2011
4 comments
797 views