Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLDR - special chars in password
>sqlload control=SAMPLE.CTL, userid=${ORAUSER}/${ORAPSWD}
I guess the comma between SAMPLE.CTL and userid is just a typo? I don't recall it belongs there. Maybe you could specify the userid in the control file itself, or use a here-document:
sqlload control=SAMPLE.CTL userid=${ORAUSER}<<EOF
${ORAPSWD}
EOF
Arjan.
Received on Thu Sep 24 1998 - 12:23:35 CDT