SQLLoader，密码包含@符号 [英] SQLLoader with a password that contains @-signs

问题描述

在Windows XP中，我启动sqlloader.exe将数据加载到Oracle.在我的密码包含@符号之前，此方法非常有效，sqlloader参数也使用该符号来确定要连接到的数据库:sqlldr.exe userid/password @ database control = ctrlfile.ctl

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

如何使sqlldr.exe接受p @ ssword之类的密码?

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

我尝试使用单引号/双引号:sqlldr.exe"user/p @ ssword" @database没有成功. 我试图跳过整个用户/密码，在控制台上键入它，但没有成功.

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.

即使google也帮不了我(尽管它使我进入了这个很棒的网站).

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

推荐答案

使用parfile也会失败.您只需要使用\转义密码，如下所示:username/\" p @ ssword \"@ database

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.

干杯， 贝尔纳多

这篇关于SQLLoader，密码包含@符号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！