Histogram Data is Corrupted After Importing Data Using Impdp or ORA-39346 is Raised While Executing Impdp
(Doc ID 2105130.1)
Last updated on MARCH 24, 2021
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.4 [Release 11.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Histogram data is corrupted after importing data using impdp or ORA-39346 is raised while importing data (in Oracle 12c) under following conditions:
- Table has NVARCHAR2 column or NCHAR column, and multibyte data is inserted in.
- Above columns have histogram data.
- Expdp is done in Oracle 11.2.0.4 or prior release.
Version matrix of the reproducibility for this problem:
| Source DB | Target DB | Histogram corrupted? | ORA-39346 raised? |
| 11.1.0.7 | 11.1.0.7 | Yes | No |
| 11.1.0.7 | 11.2.0.4 | Yes | No |
| 11.1.0.7 | 12.1.0.2 | Yes | Yes |
| 11.2.0.4 | 11.2.0.4 | Yes | No |
| 11.2.0.4 | 12.1.0.2 | Yes | Yes |
| 12.1.0.1 | 12.1.0.1 | No | No |
| 12.1.0.2 | 12.1.0.2 | No | No |
NOTE:
The error ORA-39346 was introduced in Oracle 12c to check the data.
The error ORA-39346 was introduced in Oracle 12c to check the data.
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 |
| Cause |
| Solution |