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.
Oracle Database

Avatar of undefined
Last Comment
David VanZandt

8/22/2022 - Mon
David VanZandt

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

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ajexpert

are you connected to sqlplus?

imp should be run from command prompt
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."
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
jsprenz1

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
jsprenz1

ASKER
Thank you so much
David VanZandt

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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.