Message-Id: <10637.118321@fatcity.com> From: Yosi@comhill.com Date: Mon, 2 Oct 2000 10:14:17 -0400 Subject: RE: Skipping columns with SQLLDR use FILLER, as in col_a CHAR, col_b FILLER, col_c CHAR hth, Yosi > -----Original Message----- > From: Wayne S Bellefeuille [mailto:wbellefe@allina.com] > Sent: Monday, October 02, 2000 10:35 AM > To: Multiple recipients of list ORACLE-L > Subject: Skipping columns with SQLLDR > > > Okay, so what am I missing here? > > I want to be able to use SQLLDR to load a tab-delimited file > into a table, but > the tab-delimited file has extra columns in it that I don't > want to use. How > can I build a control file to skip these extra columns in the file? > > What would the control file be for the following example: > Table: > CREATE TABLE wayne > (col_a VARCHAR2(20), > col_b VARCHAR2(20)); > > Flat file (tab-delimited): > junkcol_a datajunkjunkcol_b data > > Note that I cannot simply use positional columns here, since > the length of each > flat-file column is variable. > > Is my only choice to clean up the flat file to get rid of the > "junk" columns? > > Wayne > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Wayne S Bellefeuill > INET: wbellefe@allina.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).