Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLDR - special chars in password

Re: SQLLDR - special chars in password

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 24 Sep 1998 19:23:35 +0200
Message-ID: <6udv3q$g9$1@pascal.a2000.nl>


>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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US