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 -> escaping problem with sqlldr commandline

escaping problem with sqlldr commandline

From: Sunil <sunil_franklin_at_hotmail.com>
Date: Wed, 17 Mar 2004 11:01:33 +0530
Message-ID: <%wR5c.32$YU2.73@news.oracle.com>


The following works in windows

   sqlldr
userid=\"scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=mysvr.xyz.com
)(Port= 1521))(CONNECT_DATA=(SERVICE_NAME=901u1)))\" CONTROL=test.ctl
LOG=test.log

I am getting errors with the following in Unix

   sqlldr
userid=\"scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=mysvr.xyz.com
)(Port= 1521))(CONNECT_DATA=(SERVICE_NAME=901u1)))\" CONTROL=test.ctl
LOG=test.log

   sqlldr
userid=\'scott/tiger@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST =mysvr.xyz.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=901u1)))\' CONTROL=test.ctl LOG=test.log

   sqlldr
userid=scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=mysvr.xyz.com)( Port= 1521))(CONNECT_DATA=(SERVICE_NAME=901u1))) CONTROL=test.ctl LOG=test.log

Can any one please help? Received on Tue Mar 16 2004 - 23:31:33 CST

Original text of this message

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