This course teaches how to install and configure Windows Server 2012 R2. It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).
Oracle 11gR2 Dump Import error
Why am I getting this error when running imp.exe?
The command...
@C:\app\product\11.2.0\dbh
The result....
SP2-0042: unknown command "MZÉ" - rest of line ignored.
Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
It seems the '@' symbol is causing an error...Please help me out with this. I am delivered the dump file and have used imp in previous versions of Oracle without issue.
The command...
@C:\app\product\11.2.0\dbh
The result....
SP2-0042: unknown command "MZÉ" - rest of line ignored.
Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
It seems the '@' symbol is causing an error...Please help me out with this. I am delivered the dump file and have used imp in previous versions of Oracle without issue.
Who is Participating?
Rerun the command but leave off the @ character -- presumably you are executing this in Windows from a CMD prompt.
Yes I am running from Windows command prompt connected to sqlplus. If I leave the @ symbol off it returns "SP2-0024: Nothing to change."
slightwv is correct. It should be run outside of sqlplus. It has been quite some time since I ran imp.exe and just thought it was sqlplus. Thank you all for your help
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
Are you trying the run imp.exe from sqlplus?
If so, it is a command line program not a sqlplus program.