Thank you, it works. David -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael Twaddell Sent: Friday, March 12, 2004 12:18 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Sqlldr to remove 1st line of data file 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------