My Oracle Support Banner

Import Fails With Errors IMP-20 Long Column Too Large For Column Buffer Size (22) IMP-9 IMP-18 (Doc ID 341784.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
HP OpenVMS Alpha
***Checked for relevance on 26-Apr-2013***


An import with the following command fails with IMP-19 IMP-20 IMP-18:

#> imp v500/v500 fromuser=v500 touser=v500 file=asc_domain.dmp log=ccluserdir:v500_import.log buffer=1024000 ignore=y grants=y commit=y

Connected to: Oracle9i Enterprise Edition Release - Production
With the Real Application Clusters option
JServer Release - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. . importing table "ABN_CROSS_REFERENCE" 1 rows imported
. . importing table "ABN_RULE" 1 rows imported
. . importing table "ABO_TESTING" 110 rows imported
. . importing table "ABSTRACTING" 20 rows imported
. . . . . . . . .
. . . . . . . . .
. . importing table "CQM_MICRODNLD_TR_1" 1 rows imported
. . importing table "CQM_OENINTERFACE_QUE"
IMP-00009: abnormal end of export file
IMP-00020: long column too large for column buffer size (22)
IMP-00018: partial import of previous table completed: 15029 rows imported
Import terminated successfully with warnings.

The import with SHOW=Y into the source database will be successful. The import will abort with IMP-9 using parameters SHOW=Y and INDEXFILE after being run through the zip utility.


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.