SQLLoader with a password that contains @-signs

Question

In windows xp, I start sqlloader.exe to load data onto Oracle. This works great, until my password contains an @-sign, that is also used by sqlloader parameters to determine the database to connect to: sqlldr.exe userid/password@database control=ctrlfile.ctl

How can I make sqlldr.exe accept a password like p@ssword?

I tried with single/double quotes: sqlldr.exe "user/p@ssword"@database without success. I tried to skip the whole user/password, to type it in on the console, without success.

Even google couldn't help me (though it brought me on thsi great website).

Answer 1

It will fail using parfile as well. You just need to escape the password with \" as follows: username/\"p@ssword\"@database

not sure why nobody posted this solution before.

Cheers, Bernardo