OraFAQ Forum: Server Utilities » sqlldr - Skip header in all Infiles

Home » RDBMS Server » Server Utilities » sqlldr - Skip header in all Infiles

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlldr - Skip header in all Infiles [message #356395]

Thu, 30 October 2008 11:03

Amom
Messages: 3
Registered: October 2008

Junior Member

Hello everyone,

utility: sql loader

Here is my problem:I need to upload data from multiple Infiles into the database table. While doing so, I would like to suppress or skip header line of each file. Is there a similar function to 'skip' or any other way to ignore header from every infile.

Here is my control file:

LOAD DATA
INFILE file1.CSV
......
INFILE file[n].CSV
REPLACE
INTO TABLE CSV_IMPORT
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
( a, b, c)

Thanks a lot

[Updated on: Thu, 30 October 2008 11:05]

Report message to a moderator

Re: sqlldr - Skip header in all Infiles [message #356403 is a reply to message #356395]

Thu, 30 October 2008 11:17

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Maybe SKIP itself?

Regards
Michel

Report message to a moderator

Re: sqlldr - Skip header in all Infiles [message #356406 is a reply to message #356395]

Thu, 30 October 2008 11:23

Amom
Messages: 3
Registered: October 2008

Junior Member

Unfortunately, Skip function is skipping the header in only the first infile and not in the rest Sad

Sad

Report message to a moderator

Re: sqlldr - Skip header in all Infiles [message #356412 is a reply to message #356406]

Thu, 30 October 2008 11:52

Barbara Boehmer
Messages: 9091
Registered: November 2002
Location: California, USA

Senior Member

I believe you will need to use a separate control file for each infile, in order to skip the header row in each infile.

Report message to a moderator

Re: sqlldr - Skip header in all Infiles [message #356629 is a reply to message #356412]

Fri, 31 October 2008 10:20

Amom
Messages: 3
Registered: October 2008

Junior Member

Thanks - I wanted to avoid that, but looks like that's the only way.

Report message to a moderator

Previous Topic:	SQL*Loader-350: Syntax error at line 12
Next Topic:	External table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 22:15:36 CDT 2024