Joalkat
asked on
Command Prompt Error in Oracle SP2-0042 Unknown Command
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
LOAD DATA
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'
TRUNCATE
INTO TABLE trex_inv_items_mfg_copics_ stg
FIELDS TERMINATED BY "~"
TRAILING NULLCOLS
(
MITEM CHAR "TRIM(:MITEM )",
MLLC CHAR "TRIM(:MLLC )",
MRACN CHAR "TRIM(:MRACN )",
MTYPN CHAR "TRIM(:MTYPN )",
.....many more rows....
)
Thanks.
Joalkat
-- This is the SQL*Loader for Items
LOAD DATA
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'
TRUNCATE
INTO TABLE trex_inv_items_mfg_copics_
FIELDS TERMINATED BY "~"
TRAILING NULLCOLS
(
MITEM CHAR "TRIM(:MITEM )",
MLLC CHAR "TRIM(:MLLC )",
MRACN CHAR "TRIM(:MRACN )",
MTYPN CHAR "TRIM(:MTYPN )",
.....many more rows....
)
Thanks.
Joalkat
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER