I'm trying to create a control file in the command prompt, so I can load a flat file (tilde delimited) but I keep getting an error when the LOAD DATA command is invoked. Here's the script and what am I doing wrong?
-- This is the SQL*Loader for Items
INFILE 'Z:\JR Osuna\extracts_items tilda delimited\ITEMS_MFG.txt'
BADFILE 'Z:\JR Osuna\extracts_items tilda delimited\ITEMS_MFG.bad'
DISCARDFILE 'Z:\JR Osuna\extracts_items tilda delimited\ITEMS_MFG.dsc'
INTO TABLE trex_inv_items_mfg_copics_stg
FIELDS TERMINATED BY "~"
MITEM CHAR "TRIM(:MITEM )",
MLLC CHAR "TRIM(:MLLC )",
MRACN CHAR "TRIM(:MRACN )",
MTYPN CHAR "TRIM(:MTYPN )",
.....many more rows....