IMP Raises IMP-00020, IMP-00057 (Doc ID 259501.1)

Last updated on DECEMBER 15, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 9.0.1.5 - Release: 8.1.7 to 9.0.1
Information in this document applies to any platform.

Symptoms

A partitioned table containing unused columns is exported with EXP using DIRECT=Y. When importing the dump file the following errors are raised

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing ADMSARC's objects into ADMSARC
. . importing partition "TBLMOVTARJETAS":"P200007"
IMP-00020: long column too large for column buffer size (1)
IMP-00057: Warning: Dump file may not contain data of all partitions of this table

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