Oracle 11gR2 Dump Import error

Posted on 2012-12-20
Medium Priority
Last Modified: 2012-12-20
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.
Question by:jsprenz1
LVL 23

Expert Comment

ID: 38711883
Rerun the command but leave off the @ character -- presumably you are executing this in Windows from a CMD prompt.
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 38711885
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.
LVL 14

Expert Comment

ID: 38711886
are you connected to sqlplus?

imp should be run from command prompt
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 38711924
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 Comment

ID: 38711928
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 Closing Comment

ID: 38711929
Thank you so much
LVL 23

Expert Comment

ID: 38711977
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.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question