My Oracle Support Banner

Mysql To Oracle Data Migration - copy fails with "can not insert a NULL into a NOT NULL column" (Doc ID 2571008.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle SQL Developer - Version 18.4 and later
Microsoft Windows x64 (64-bit)


Attempting to migrate a MYSQL 5.6 database to an Oracle 12.2 database using SQL Developer  Not all tables are migrated successfully.
It is observed that the number of tables created using SQL Developer migration assistant are fewer than the source. 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.