My Oracle Support Banner

ORA-02291 ORA-06512 During Migration Capture of SQL Server Using SQL*Developer Migration Workbench (Doc ID 1915677.1)

Last updated on AUGUST 04, 2018

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"


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.