i want to migrate from mysql to oracle. In my mysql schema are pubchem data which i imported since a year.
I do the migration like the documentation here: http://docs.oracle.com/cd/E25259_01/appdev.31/e24285/migration.htm#CHDIJEBC
It works and the sqldeveloper told me that the migration completed but not all tables are filled with data. Some have no data and some have less data as in the mysql database.
Which reason could it be that only some data are copied?
I have resized the tablespace because in my first migration run the size exceeded.
But now there is enough space but i doesn't work.
I hope anybody could help me
Did you move the data using the online or offline method ?
It is better if you can move the data offline as this gives more control and it is easier to see what the problems may be.
COuld you try moving the data using the offlime method and see what happens ?