473,387 Members | 1,515 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 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 10532
problem solved!! Hope that you can help me another time :) I just deleted OPTIONALLY ENCLOSED BY "" and it worked...
Oct 15 '07 #2

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

Similar topics

2
by: Bo Brunsgaard | last post by:
I have a problem trying to run SQL*Loader after migrating to Oracle 9. It used to run with no hicups on Oracle 8i, and I'm at my wits' end. Any help? I'm trying to run SQL*Loader from a command...
2
by: Anus | last post by:
Can the SQL Loader utility load data into another user's table? note: this USER has select,update insert and delete privileges on the other user's tables
6
by: Hari Om | last post by:
Here are the details of my error log files: I execute the command and get following message at console: ---------------------------------------------------------------------- ../sqlldr...
0
by: gaikwadrachit | last post by:
Hi We are uploading a picture image(jpg) as a BLOB in a table using SQL Loader. We are parallely uploading the images at the same time from 2 different sessions on the server. The command for...
1
by: devasmita | last post by:
hi all, could anybody give me a solution....how can I rollback in SQL * Loader.....
1
by: gkata | last post by:
I have a file that originated on the mainframe that contains both text and packed fields. I'm using sql loader to load a Oracle table, but I'm having difficulty with the packed fields loading...
1
by: jith87 | last post by:
hi, i am importing a text file into oracle database using sql loader.i need to ommit the first and last records of the text file while importing... can anybody help???? this is my text file... ...
4
by: badam571 | last post by:
How to encrypt the user-id/password to pass to sql loader function. any help? Best Regards
2
by: ragonz | last post by:
im having trouble in executing sql loader command in php. i already posted this issue in php forum, but didn't give me clear answer yet. probably posting in this forum would be better. here's...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.