asked on
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.
Oracle Database
Last Comment
David VanZandt
Rerun the command but leave off the @ character -- presumably you are executing this in Windows from a CMD prompt.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
are you connected to sqlplus?
imp should be run from command prompt
imp should be run from command prompt
ASKER
Yes I am running from Windows command prompt connected to sqlplus. If I leave the @ symbol off it returns "SP2-0024: Nothing to change."
ASKER
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
ASKER
Thank you so much
Always glad to help. There were three correct answers, all nearly at the same time. It's a common practice for the author to split the points award, mentioned simply in case you were not aware. Thanks for subscribing.