Thanks for the question, Ruchira.
Asked: May 05, 2017 - 1:20 pm UTC
Last updated: May 06, 2017 - 2:44 am UTC
Version: ORACLE 11.2.0.3
Viewed 1000+ times
You Asked
Hi Tom,
I am trying to import a schema that was exported using old export method (EXP), when importing the schema after some time i get below errors
IMP-00019 row rejected due to ORACLE error 1400
IMP-0003 ORACLE error 1400 encountered
ORA-01400 cannot insert NULL into ("SIEBEL".EIM_CON_DTL_19DEC2016_X_XM".ROW_ID)
This error repeats with column numbers.
Is is possible to use IGNORE=Y when importing and avoid this error, or is there a workaround ??
Thanks,
Ruchira
and Connor said...
"Is is possible to use IGNORE=Y"
Yes it is, but the error suggests you are trying to insert data from a source into *differently* defined tables (ie, the source allows null and the target does not).
Is that your intention ? If you don't want to lose those rows, you might need to make the column allow nulls for the duration of the import, and then create a not null constraint afterwards (eg with 'enable novalidate')
Is this answer out of date? If it is, please let us know via a Comment