Import Submit Failed There is a problem reading from the import files: ORA-39143: dump file "c:\temp\case9_0.DMP" may be an original export dump file .
There appears to be two import tools and Enterprise Manager only knows about 'impdp'. There is the old import tool 'imp' that is needed if the dump file was created using 'exp' as opposed to 'expdp' or via Enterprise Manager.
The solution.
Simply run:
where user & password are for the user in the dump file and it will prompt you for all the answers.
imp user/password
3 comments:
Nice! I'll remember that as those awful Oracle errors messages seem to mean nothing most of the time! ;)
and an example command in full:
imp system/password FILE=filename.dmp fromuser=someuser touser=anouser
Post a Comment