12c Data Pump Import From 10.2 or 11.1 Is Missing Some UNIQUE Indexes
(Doc ID 2133613.1)
Last updated on APRIL 03, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
On : 12.1.0.2 version, Data Pump Import (impdp)
ACTUAL BEHAVIOR
---------------
When performing Data Pump import from a 10.2 or 11.1 source into 12.1.0.2, some of the UNIQUE indexes are not included in import. The same dumpfile imports the unique indexes fine into 11g.
When using the SQLFILE option to check in 10g or 11g, it properly shows the CREATE UNIQUE INDEX statement.
For example:
EXPECTED BEHAVIOR
-----------------------
All indexes should be imported.
Changes
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 |