EXP/IMP problem when password has special characters
9984Jan 5 2007 — edited Jan 5 2007I have to use the legacy EXP/IMP for export/import of data in my application (data pump not an option in this case). Our users are allowed to have special characters in their passwords, including the at (@) sign (because they are quoted). This poses no problem logging into the application, or into SQL*Plus.
However, a command line process is kicked off in the .Net app that can do exp or imp. I get ORA-12154 (TNS:could not resolve the connect identifier specified) on the exp/imp if the password is something like this: app123!@#. I believe the at sign is causing the problem because if I leave that character out then I get a ORA-01017 (invalid username/password; logon deniedUsername).
I have tried various combinations of quoting (single and double) the password but to no avail and escaping the at sign. Here is a sample of the command running is a DOS window (Oracle 10.2). The double quotes are not part of the password.
imp user1/"app123!@#"@DB01 ....
Of course this works fine if the password does not have the at sign (@). Am I out of luck or is there a way around this. I can't respond to prompts because this runs from with an application.
Bob