Oracle 11gR2 Dump Import error

jsprenz1
jsprenz1 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David VanZandtOracle Database Administrator III

Commented:
Rerun the command but leave off the @ character -- presumably you are executing this in Windows from a CMD prompt.
Most Valuable Expert 2012
Distinguished Expert 2018
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.

Commented:
are you connected to sqlplus?

imp should be run from command prompt
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

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

Author

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

Author

Commented:
Thank you so much
David VanZandtOracle Database Administrator III

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial