OraFAQ Forum: Server Utilities » SQL*Loader does not load files if the path contains &

Home » RDBMS Server » Server Utilities » SQL*Loader does not load files if the path contains &

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*Loader does not load files if the path contains & [message #71323]

Wed, 16 October 2002 01:32

Cristian Diaconu
Messages: 4
Registered: July 2002

Junior Member

SQL*Loader does not load files if the path contains the "&" character. I tried using single and double quotas, as well as "" for escaping. Still doesn't work. Please help.
Thank you.

Report message to a moderator

Re: SQL*Loader does not load files if the path contains & [message #71327 is a reply to message #71323]

Wed, 16 October 2002 07:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

that depends on the OS.
what your OS?

C:mag>type emp.ctl
load data
infile 'EMP&E.txt'
replace
into table test_DATE
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(
D date
)

C:mag>sqlldr userid=mag/mag control=emp.ctl

SQL*Loader: Release 8.1.6.0.0 - Production on Wed Oct 16 11:15:43 2002

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 13
Commit point reached - logical record count 14

Report message to a moderator

Re: SQL*Loader does not load files if the path contains & [message #71329 is a reply to message #71327]

Wed, 16 October 2002 07:53

Cristian Diaconu
Messages: 4
Registered: July 2002

Junior Member

I have MS Win2000 Professional
My problem is that the "&" sign is in the path to the file, not in the file name. That is: c:tempas&bstext.dat
Can you please help me with that?

Report message to a moderator

Previous Topic:	SQL Loader -- Convert invalid dates to null?
Next Topic:	Effect of "CAT" scripts on other databases

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 16 09:00:02 CST 2026