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 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Apr-2013Y***

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

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

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