Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export Database With Password Containing Special Characters

690684Aug 10 2009 — edited Aug 11 2009
Hi,

I'm doing a database export using the command:

exp userid=user/pass@instance parfile=exp_parms.dat

The problem is that the password contains special characters so the command fails with a syntax error. The command works perfectly fine when I run it without the password and just type it in when prompted, but I need to include the password in the command because I am running it in a batch file. I've tried using the escape character (\), but this results in a username-password mismatch.

Is there some way of declaring a password containing special characters in the 'exp' command?

...Thanks in advanced!
This post has been answered by Dean Gagne-Oracle on Aug 11 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2009
Added on Aug 10 2009
4 comments
6,516 views