Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sqlldr to remove 1st line of data file

Re: Sqlldr to remove 1st line of data file

From: Michael Twaddell <twaddell_at_raytheon.com>
Date: Fri, 12 Mar 2004 12:17:59 -0600
Message-ID: <4051FED7.80404@raytheon.com>


David,

You should be able to use the SKIP sqlldr parameter

    sqlldr userid=joeuser/password skip=1 control=control_file_name

This will skip over the first logical record in your data file.

Michael T.

Nguyen, David M wrote:

> I want to load data file into oracle database and I need to remove the
> first line inside of data file before loading. How do I tell sqlldr to
> remove the first line of data file?
>
> **My data file in csv format:
>
> *# Northeast,1,GABE0,66.89.254.25**** <=== Need to remove this line
> before loading data.*****
>
> 2/27/04 10:44:52 PM CST,13,13,0,43,0,446,0
>
> 2/27/04 10:59:52 PM CST,3,3,0,15,0,446,0
>
> 2/27/04 11:14:52 PM CST,7,7,0,23,0,446,0
>
> 2/27/04 11:29:52 PM CST,7,6,1,18,0,446,0
>
>
> Thanks,
> David
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Mar 12 2004 - 12:15:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US