Traditional Import (IMP) Fails With Errors IMP-32 IMP-8 When Importing Into Database With Character Set AL32UTF8 From A Database With Character Set WE8MSWIN1252
(Doc ID 789158.1)
Last updated on AUGUST 02, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 and laterOracle 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
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When performing a full import the following errors occurred:
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'A string describing other relevant information on the status of the database.
If the value of the EnabledState property is set to anything other than 1, this
property MUST be set to NULL.'
IMP-00008: unrecognized statement in the export file:
'A string describing other relevant information on the status of the database.
If the value of the EnabledState property is set to anything other than 1, this
property MUST be set to NULL.'
Changes
Source database character set: WE8MSWIN1252
Target database character set: AL32UTF8
Tried the import again with the parameter BUFFER but same errors occurred.
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 |