471,353 Members | 1,536 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,353 software developers and data experts.

TAB delimited data and SQL*LOADER

Hello again, I am having a problem to import data in my tables with SQL loader.
I have made the following control file with textpad and saved it in UNIX format as a *. txt file which I named MY_CROPS.CTL
LOAD DATA
INFILE /home/klein/mein/data/MY_CROPS.DAT
REPLACE
INTO TABLE MY_CROPS
FIELDS TERMINATED BY X'09'OPTIONALLY ENCLOSED BY ""
(CROP, NAME, START_OF_SEASON, END_OF_SEASON)

The MY_CROPS.CTL file is stored in /home/klein/mein/control_files/MY_CROPS.CTL

When I try to run sqlldr control=/home/klein/mein/control_files/MY_CROPS.CTL discard=/home/klein/mein/discard_files/MY_CROPS.dsc SKIP=2 in UXIX I get the following error:

SQL*Loader-350: Syntax error at line 2.
Illegal combination of non-alphanumeric characters

I tried to put <> in my path but didnt work... what are my other options please? trying to solve it for ages now...
Oct 15 '07 #1
1 10256
problem solved!! Hope that you can help me another time :) I just deleted OPTIONALLY ENCLOSED BY "" and it worked...
Oct 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Bo Brunsgaard | last post: by
reply views Thread by gaikwadrachit | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.