Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLDR - special chars in password
In article <6udv3q$g9$1_at_pascal.a2000.nl>,
"Arjan van Bentem" <avbentem_at_DONT-YOU-DAREdds.nl> wrote:
> >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.
>
>
Arjan, Thanks. I should have mentioned in my post that I did try putting it in
the control file without luck. Also, the comma seems to be required.
Jim
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 24 1998 - 14:52:11 CDT