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

Last updated on AUGUST 04, 2018

Applies to:

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 ("GENERAL"."GLBEXTR"."GLBEXTR_CREATOR_ID")
Column 1 STUDENT
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 "sys/''p1' as sysdba" file='dmpfile' buffer=4096000 ignore=y full=y log=imp.log

ksedst ksedmp ksddoa ksdpcg ksdpec kgesev ksesec1 insLoadRowFastPath 1098427 insdrvFastPath 223 inscovexe insexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o main 

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

Cause

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