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

Applies to:

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

Symptoms

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 9.2.0.3.0 - Production
With the Real Application Clusters option
JServer Release 9.2.0.3.0 - 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.

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