Import Fails With Errors IMP-9 IMP-20 IMP-18 On OpenVMS (Doc ID 309020.1)

Last updated on NOVEMBER 28, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 9.2.0.5 - Release: 9.2 to 9.2
HP OpenVMS Alpha

Symptoms

Export of 9.2.0.5 with source database characterset US7ASCII and NLS_LANG setting to AMERICAN_AMERICA.

Export parameters:

#> exp buffer=10485760 rows=yes indexes=no grants=no file=datafile_exp log=logfile_exp tables=(FISWH.ACCT, ACCT_TYPE, ACTV, AGENCY, FISCAL_PERIOD, FIXED_ASSETS, FIXED_ASSETS_FUNDING, FUND FUND_TYPE, GENERAL_LEDGER, GRNT, INDX, LOCN, OPERATING_LEDGER, ORGN,PAYROLL_LEDGER_ENCUMB, PROG PROJ, TRANSACTION_LEDGER, VEND, VEND_ADDR, JOBLOG_FISWH, AUDIT_SOURCE)

Import parameters:

#> imp 'uidpw' file=datafile_imp buffer=1048576 log=logfile_imp indexes=n rows=y ignore=y fromuser=fiswh touser=fiswh_5 commit=y

All data files are under 2GB, generally sizes are in range from 80-400MB. The dump files are produced on instance A of Node A of a VMS cluster and the import is done to Instance B of  Node B. There is no ftp process necessary as the nodes all have access to the disk devices.

Export log file:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
 
About to export specified tables via Conventional Path ...
. . exporting table                           ACCT      28325 rows exported
. . exporting table                      ACCT_TYPE        970 rows exported
. . exporting table                           ACTV      15886 rows exported
. . . .
. . exporting table                   AUDIT_SOURCE       1134 rows exported
Export terminated successfully without warnings.

Import log file:
 
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
 Export file created by EXPORT:V09.02.00 via conventional path
 Warning: the objects were exported by FISWH, not by you
 
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. importing FISWH's objects into FISWH_5
. . importing table                         "ACCT"
IMP-00009: abnormal end of export file
IMP-00020: long column too large for column buffer size (7)
IMP-00018: partial import of previous table completed: 4700 rows imported
Import terminated successfully with warnings.

Changes

Upgraded onto 9.2.0.5 from 9.2.0.3.

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