Link to home
Start Free TrialLog in
Avatar of jsprenz1
jsprenz1

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\dbhome_1\BIN\imp.exe infodba/infodba fromuser=infodba touser=infodba file=C:\InstallSoftware\sidprodday1.dmp commit=y log=log.txt

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.
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Rerun the command but leave off the @ character -- presumably you are executing this in Windows from a CMD prompt.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
are you connected to sqlplus?

imp should be run from command prompt
Avatar of jsprenz1
jsprenz1

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."
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
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.