问题描述
在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,密码包含@符号的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!