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 9.2.0.5 to 10.1.0.3 [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

Symptoms

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

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 -
      statistics=none

 

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.