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 APRIL 16, 2013

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

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