| SQL*loader [message #70897] |
Fri, 09 August 2002 06:43  |
Sara Janmyr
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
Hi,
I'm trying to do the simplest thing using SQL*Loader, importing data from a comma seperated file. The thing is that SQL*loader will not accept the command:
fields terminated by ",".
When I run sql*loader I get: 'sql*loader-350:expected keyword INFILE, INTO or (EOF)'.
My controlfile looks like this:
load data
infile 'c:SQLLoadermydata2.csv'
into table sara (nummer,text)
fields terminated by ","
I'm going nuts, is there a version change or something??
|
|
|
|
| Re: SQL*loader [message #70898 is a reply to message #70897] |
Fri, 09 August 2002 07:18  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
try this. switch the 3rd and 4th lines
load data
infile 'c:SQLLoadermydata2.csv'
fields terminated by ","
into table sara (nummer,text) |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
