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 laterOracle 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 |