I'm using SQL Developer to migrate a database from MySQL 5.7 to Oracle 18c XE. The problem is that the tables are generated but empty, even though I'm specifying that the data should move online. I also looked at the scripts, and there's no data either.

What I see in the log is DataMove.DISABLE_CONSTRAINTS_FAILED. How to fix this?

These are the migration options:

enter image description here


Solution: create a user/schema in Oracle that has the same name as the database you want to import.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.