IMP-00019 ORA-1400 ON IMPORTING A 9205 DATABASE TO 10103

(Doc ID 353666.1)

Last updated on OCTOBER 14, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 10.1.0.3
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 ("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

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