My Oracle Support Banner

IMP-00019 ORA-1400 ON IMPORTING A 9205 DATABASE TO 10103 (Doc ID 353666.1)

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
HP OpenVMS Alpha
Digital Alpha OpenVMS
HP OpenVMS Alpha


An export DMP file from is transferred to another server for import into

The import fails with

IMP-00019: row rejected due to ORACLE error 1400
IMP-00003: ORACLE error 1400 encountered
ORA-01400: cannot insert NULL into ("<SCHEMA>"."<TABLE>"."<COLUMN>")
Column 1 ..............
Column 2 ..............
Column 3
Column 4
Column 5
Column 6
Column 7
Column 8

Export commands are:

exp userid="''userpasswd'" -
      buffer='export_buffer' -
      file=export_location:export_'db_name'_'export_mode'.dmp -
      full=y -
      grants=y -
      indexes=y -
      rows=y -
      constraints=y -
      compress=n -


Import commands are:

imp <USER>/<PASSWORD> as sysdba file='dmpfile' buffer=4096000 ignore=y full=y log=imp.log

ksedst ksedmp ksddoa ksdpcg ksdpec kgesev ksesec1 insLoadRowFastPath insdrvFastPath inscovexe insexe ...

Testing the import process with SHOW = Y fails at the same point in the process.




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.