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.
Received on Mon Nov 06 2000 - 15:06:16 CST
