Home » RDBMS Server » Server Administration » SQLLOADER QUESTION
SQLLOADER QUESTION [message #373318] Wed, 11 April 2001 08:44 Go to next message
Eric
Messages: 78
Registered: April 1999
Member
Hi,

Here my problem.

I Have a source file (semi colon delimited file (CSV) with 50 columns.
I have a dest table with 5 coloums.

I want to load only the field 3,8,32,41,45 from my source file.

How can I built my sqlloader?

Thanks,

Report message to a moderator

Re: SQLLOADER QUESTION [message #373327 is a reply to message #373318] Wed, 11 April 2001 12:32 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
http://www.ibi.co.za/frank/faqloadr.htm#SKIPCOL

http://osi.oracle.com/~tkyte/SkipCols/

Report message to a moderator

Previous Topic: SQL stmt
Next Topic: A date field in a primary key
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 10:06:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.