All geek questions in one place

SQLLoader with password containing @ -values

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

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

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

Even Google could not help me (although this led me to a great website).

+4
source share
2 answers

He will also not be able to use parfile. You just need to hide the password with \ "as follows: username / \" p @ssword \ "@ database

I don’t know why no one has sent this solution before.

Cheers, Bernardo

+5
source

Have you tried it using the options file? I think this will allow you to have any password you want. From the Oracle site:

PARFILE = path_ file_name

Tells SQLLoader to read command line parameter values ​​from a text file. This text file is called a parameter file and contains pairs of keywords / values. Typically, keyword / value pairs are separated by line breaks. Using the PARFILE parameter can save a lot of time if you need to execute the same load several times, because you will not need to re-specify all the command line parameters every time. There is no default extension for parameter files. *

0
source

Source: https://habr.com/ru/post/1309559/

More articles:


All Articles