Oracle import not completing cleanly ?
Posted on 2008-06-18
I'm running an ORACLE import on WIndows (XP) using the following command:
imp username/passwd file=file.dmp tables=* ignore=y feedback=10000
The data imports without a problem, however it seems to hang forever at the end.
e.g. I see the following output...
. importing CRM_LIVE's objects into CRM_LIVE
. . importing table "ADDRESS" 253693 rows imported
. . importing table "TELEPHONE" 280072 rows imported
. . importing table "USER_DATA" 1727 rows imported
without ever seeing a 'Import completed successfully' message.
If I run taskmgr I can see 'IMP.EXE' still running (though not consuming any CPU).
I can simply 'CTRL-C' to get out of this, however I'm trying to kick off this process via a Java program (which waits for it to finish before continuing).. the 'hanging' behaviour prevents this working as it appears as though the process is still running.
How can I
- double check that 'imp' really has finished its work
- force it to terminate cleanly ?