My Oracle Support Banner

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 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
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


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


Source database character set: WE8MSWIN1252
Target database character set: AL32UTF8

Tried the import again with the parameter BUFFER but same errors occurred.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.