ORA-02291 ORA-06512 During Migration Capture of SQL Server Using SQL*Developer Migration Workbench

(Doc ID 1915677.1)

Last updated on SEPTEMBER 23, 2014

Applies to:

Oracle SQL Developer - Version 4.0 and later
Information in this document applies to any platform.


Attempting to migrate a SQL Server database to Oracle using SQL Developer Migration Workbench.

During the capture phase of an offline migration, the following error occurs:

CaptureColumns:inserting column [ORA-02291: integrity constraint (MGREP.MD_COLUMNS_MD_TABLES_FK1) violated - parent key not found
ORA-06512: at "MGREP.SS2K5ALLPLATFORM", line 1624]nSvrId:table_id_fk:column_name:column_order =67170601: 67190551: updatedBy: 7"


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms