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)

Symptoms

Attempting to migrate a MYSQL 5.6 database to an Oracle 12.2 database using SQL Developer 18.4.0.376.  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. 

Cause

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
Symptoms
Cause
Solution
References


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