Home » RDBMS Server » Server Utilities » sql loader issue
sql loader issue [message #240213] Thu, 24 May 2007 06:44 Go to next message
Messages: 60
Registered: November 2006
Location: India

Hello all
I want to load data into two table using a single data file
when i am using .PRN file it is ok..
But when i am using .CSV format it is not working

Plz give suggesion .. the code of Control file is

load data
infile *
into table custom.ram
fields terminated by ',' optionally enclosed by '"'
(ename,dname,sal ,jdate date "DD-Month-YYYY")
into  table custom.ramu

Shakti Goyal

[EDIT reason: message reformatting]

[Updated on: Thu, 24 May 2007 07:08] by Moderator

Report message to a moderator

Re: sql loader issue [message #240221 is a reply to message #240213] Thu, 24 May 2007 07:07 Go to previous message
Messages: 20849
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You are member of the OraFAQ Forum for several months now and you should know better how to post a question here.

"My car is broken - how can I fix it?" type of questions are out of question. What does it mean "it is not working?" How are we supposed to know if you don't post error message you received?

PRN and CSV files? Where are they? Your example doesn't contain any of those.

Message formatting is poor; I'll remove it.

Finally, why are you posting a SQL*Loader-related question on Forms Forum?
Previous Topic: IMP-00002: error
Next Topic: Changing Characterset from AL16UTF16 to AL32UTF8
Goto Forum:

Current Time: Fri Oct 21 16:11:10 CDT 2016

Total time taken to generate the page: 0.17773 seconds