Re: SQL*Loader question

In the latest versions of Oracle, there's a FILLER column spec that tells loader to ignore the column. Works great - if you're on the right version of Oracle. (8.1.6 possibly.)

FWIW, Yosi

RROGERS_at_galottery.org wrote:

> In your control file you can list the column position of the data for the field is they are always in the same char position(fixed format records). Fld1 1:12 fld2 13:19 etc.
> I have tried to load data into a table and not load the first column that was included in the source data and could not easily get it to work. There may be a way but I could not get it this am during tests. You could load the data into a temp table and then insert into with a select clause if the tables are not really large. I would also write a procedure to load the end table with the final data and commit the data every so many records loaded.
> ROR ª¿ª
>
> >>> charliem_at_mwh.com 11/06/00 04:10PM >>>
> I have a decent number of BIG flat files that need to get loaded into Oracle.
> The 1st field of each of these records is the "table_name". I do NOT want to
> load this field into Oracle. These are variable formated records with fields
> separated by TAB characters. I just want to load fields 2 - 6 and avoid
> loading field #1. How can I avoid loading the table_name into Oracle
> using sqlldr? I know I could "solve" this problem by re-writing the
> flat files without this data, but I'm hoping for a better solution.
>
> below is a sample control file used to load all the fields.
>
> -- sqlldr username/password log=ar.hist.log control=load_raw_pick.ctl
> -- Loads data extracted from PICK into the Oracle table RAW_PICK
> OPTIONS (DIRECT=TRUE, ERRORS=99999)
> UNRECOVERABLE
> LOAD DATA
> INFILE DONE_ORDER.HISTORY_011.TXT
> BADFILE DONE_ORDER.HISTORY_011.bad
> DISCARDFILE DONE_ORDER.HISTORY_011.dsc
> DISCARDMAX 99999
> APPEND INTO TABLE RAW_OHH
> FIELDS TERMINATED BY X'09'
> ( TABLE_NAME, KEY, COLUMN#, VALUE#, SUBVALUE#, STRING)
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct
> 858-831-2229 San Diego, CA 92131
> You don't know what you don't know. Think about it.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.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_at_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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> 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_at_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).

--
Thanks,

Yosi


---------------------------------------------------------
Yosi Greenfield