My Oracle Support Banner

DataPump Import (IMPDP) Reports ORA-14063 When Loading Constraints (Doc ID 2446610.1)

Last updated on OCTOBER 18, 2018

Applies to:

Oracle Database - Standard Edition - Version 11.1.0.7 to 12.1.0.1 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Symptoms

DataPump import job reports ORA-39083/ORA-14063 when processing /TABLE/CONSTRAINT/CONSTRAINT:

> impdp test/test dumpfile=test4sr.dmp

Import: Release 12.1.0.1.0 - Production on Thu Sep 13 03:49:13 2018

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "TEST"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TEST"."SYS_IMPORT_FULL_01":  test/******** dumpfile=test4sr.dmp
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"TEST" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
.......
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TEST"."TAB1"                                   0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39083: Object type CONSTRAINT:"TEST"."PK_TAB1" failed to create with error:
ORA-14063: Unusable index exists on unique/primary constraint key
Failing sql is:
ALTER TABLE "TEST"."TAB1" ADD CONSTRAINT "PK_TAB1" PRIMARY KEY ("COL1") USING INDEX "TEST"."PK_TAB1"  ENABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Job "TEST"."SYS_IMPORT_FULL_01" completed with 2 error(s) at Thu Sep 13 03:49:20 2018 elapsed 0 00:00:05

Changes

The index is in UNUSABLE  status on source database.

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
Changes
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.