Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMP-00009: Abnormal end of export file

755639Dec 14 2011 — edited Dec 14 2011

Dear All,

While on import into 9.2.0 database i am getting this error when the import stops.

IMP-00009: Abnormal end of export file

More over i am not getting the full tables from schemas, Empty data tables are not imported, can anyone tell me is the dump was not exported correctly ! or i am doing wrong import.

from the same dump file i am doing another schema which giving me this below error :

IMP-00019 : row rejected due to ORACLE error 1400
IMP-00003 : ORACLE error 1400 encountered
ORA-01400 : cannot insert NULL into ("PRODUCTION"."REQ_CARD","IDORDER")
Column : 1
Column : 2

The above error mentioning there is table called REQ_CARD which is in PRODUCTION schema having NOT NULL in column is in it.

For this how i have to import this same.

Regards
Hamid

Exported from 8.0.4 with windows NT OS
Importing into 9.2.0 with windows XP (for testing)

Edited by: Hameed on Dec 13, 2011 10:55 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 11 2012

Added on Dec 14 2011

#general-database-discussions

5 comments

2,158 views