1.The below script works perfectly fine in dev. However, i have been told that i cannot hardcode the password into the file during production impementation. Is their way i could ask the user to enter the password when the script is executed
- I have seven different files each of which needs to be loaded to a different table.
eg
file table
a 845
b 123
( i am just making this up )
Like that there are seven differnt file and tables
If i have to use control file, sql ldr to load data, i would have to have a ctrl file,data file and a shell script shown below. which means 7*3 = 21 files in total
Is there a way i could use just one shell script that has all the ctrl files info and data file location to process all the files ?
SHELL SCRIPT
export USERID=schema@username/password
export CTRL_FILE_HOME=/SrcFiles/
export DATA_FILE_HOME=/SrcFiles/
#************ Load Data Elements info ******************************
export CTRL_FILE_NAME=DEA.CTL
export DATA_FILE_NAME=DEA.DEL
sqlldr control=$CTRL_FILE_HOME$CTRL_FILE_NAME userid=$USERID skip=0 ERRORS=20000 data=$DATA_FILE_HOME$DATA_FILE_NAME