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.
jsprenz1Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
SP2 looks like a sqlplus error.  As well as the '@' to execute a script file in sqlplus.

Are you trying the run imp.exe from sqlplus?

If so, it is a command line program not a sqlplus program.
0
 
DavidSenior Oracle Database AdministratorCommented:
Rerun the command but leave off the @ character -- presumably you are executing this in Windows from a CMD prompt.
0
 
ajexpertCommented:
are you connected to sqlplus?

imp should be run from command prompt
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

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

 
jsprenz1Author Commented:
Yes I am running from Windows command prompt connected to sqlplus. If I leave the @ symbol off it returns "SP2-0024: Nothing to change."
0
 
jsprenz1Author Commented:
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
0
 
jsprenz1Author Commented:
Thank you so much
0
 
DavidSenior Oracle Database AdministratorCommented:
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.
0
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.