EXP "terminated successfully without warnings;" IMP gives IMP-00009 and 018
EmAug 4 2009 — edited Aug 5 2009We have a PRODUCTION and a TEST database, both Oracle9i Release 9.2.0.8.0.
I am an on-the-job trained Oracle DBA (NOT really trained -- forced to learn as I go).
We have always, in the past, used an EXPORT from PRODUCTION (aka P2KLIVE) to create our TEST (aka P2KTEST) database, and it has always worked.
The databases and their export files are all on the same box.
My export command is
exp userid=system/system@P2KLIVE file=d:\db-backups\EXPORTS\P2KLIVE-yyyymmdd_hhmm.dmp consistent=y full=y log=d:\db-backups\logs\P2KLIVE-exp-yyyymmdd_hhmm.log
My result from this is
Export terminated successfully without warnings.
On the TEST side:
1) run a script to DROP (in this order) all views, sequences, triggers, functions, procedures, packages, tables, belonging to user P2K (the drop of CONSTRAINTS is commented out, but this is not something that I've done, and has always been this way);
2) IMP system/system@P2KTEST file=D:\DB-Backups\Exports\P2KLIVE-yyyymmdd_hhmm.dmp log=d:\tools\dba\Live-to-Test\LiveToTest.log fromuser=p2k touser=p2k commit=y statistics=none
The IMP goes through a small number of the tables and then returns:
IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: 267545 rows imported
Import terminated successfully with warnings.
It doesn't always fail on the same file.
I've tried it repeatedly with the same export file, but have also run new exports, with the same results.
ANY input, advice, comments would be greatly appreciated. I will do my best to discover any information that's needed to help me resolve this.
Thank you!