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 'impdb'. There is another 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
you have a nice site. thanks for sharing this valuable resources. keep it up. anyway, various kinds of ebooks are available here
http://feboook.blogspot.com
Post a Comment