12c Data Pump Import From 10.2 or 11.1 Is Missing Some UNIQUE Indexes
Last updated on JANUARY 17, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
On : 126.96.36.199 version, Data Pump Import (impdp)
When performing Data Pump import from a 10.2 or 11.1 source into 188.8.131.52, 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.
All indexes should be imported.
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