Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> escaping problem with sqlldr commandline
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