From oracle-l-bounce@freelists.org Fri Mar 12 12:02:58 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2CI2wt27252 for ; Fri, 12 Mar 2004 12:02:58 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2CI2vo27245 for ; Fri, 12 Mar 2004 12:02:58 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DFE38394920; Fri, 12 Mar 2004 13:02:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 12 Mar 2004 13:01:07 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from triton.xo.com (plasmlprd03.pla.dc.xo.com [205.158.160.113]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 14EBB395A43 for ; Fri, 12 Mar 2004 13:01:05 -0500 (EST) Received: from ilchicsimr002.mail.inthosts.net ([172.19.22.42]) by triton.xo.com (Switch-3.1.3/Switch-3.1.0) with ESMTP id i2CI4ZRX008877 for ; Fri, 12 Mar 2004 12:06:20 -0600 (CST) Received: from ILCHICVEXC002.mail.inthosts.net ([172.19.22.15]) by ilchicsimr002.mail.inthosts.net with Microsoft SMTPSVC(5.0.2195.5329); Fri, 12 Mar 2004 13:05:57 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6470.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4085C.AB304ABE" Subject: Sqlldr to remove 1st line of data file Date: Fri, 12 Mar 2004 13:05:57 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Sqlldr to remove 1st line of data file Thread-Index: AcQIXKn5eX0wy/DCR0WWuf1+Lr4ckg== From: "Nguyen, David M" To: X-OriginalArrivalTime: 12 Mar 2004 18:05:57.0695 (UTC) FILETIME=[AB497CF0:01C4085C] X-SAASFSig: 93a0c6e7d9b357919aaa4afbf79a818f X-archive-position: 711 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: david.m.nguyen@xo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C4085C.AB304ABE Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 <=3D=3D=3D 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 ------_=_NextPart_001_01C4085C.AB304ABE Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Sqlldr to remove 1st line of data file

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   <=3D=3D=3D 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

------_=_NextPart_001_01C4085C.AB304ABE-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------