Originally posted by amar
How about using a parameter file containing the userid

-amar
I have tried this, it works if the userid/password@tns is static, when I was doing this it was dynamic so using shell variables wasnt possible (at least no on Tru64), try pass the password from a file to sql loader, I think it hides the password

Somthing like
Code:
echo ${DESPWD} > /tmp/zeratul
sqlldr userid=${DESUSER}@${DESTNS} parfile=${SQLLDRCTLDIR}/sqlldr_${PATRON2}.par < /tmp/zeratul > ${SQLLDRLOGDIR}/sqlldr_${PATRON1}.log 2>> ${SQLLDRLOGDIR}/sqlldr_${PATRON1}.log