John, I didn't say that a parameter file can't be used. The correct syntax is "control=", not "parfile=".
And I agree about postings. I posted that message yesterday at around noon. FInally showed up today. But my email server is flaky. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Wednesday, September 03, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Tom, I am afraid you are wrong there, a parameter file can be used to run a sqlloader script The syntax that Fawzia uses is correct although as per imp/exp it would be better to put all the parameters in the parfile file I spent years not knowing that and in frustration posted to the list and was immediately shown how to do it Interesting to see if this reply makes it to the list as the last one I posted about 2 hours ago never got there. John -----Original Message----- Sent: 02 September 2003 19:05 To: Multiple recipients of list ORACLE-L Fawzia, Try the following (change parfile= to control=) sqlldr control=pants.ctl log=me.log parfile is for imp/exp. Good Luck! Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Tuesday, September 02, 2003 1:20 PM To: Multiple recipients of list ORACLE-L PLEASE!!!! Can someone help??I have a sqlloader control file below and I am getting the following error when I run it and I just cant see what is wrong!!! Rgds Fawzia [EMAIL PROTECTED]> sqlldr parfile=pants.ctl log=me.log LRM-00110: syntax error at 'LOAD' LRM-00113: error when processing file 'pants.ctl' Control file: LOAD DATA INFILE 'gazza2.csv' APPEND INTO TABLE olsr10_tlmif2.gazetteer1 fields terminated by ',' trailing nullcols (postcode_prefix_spaced char, filler1 char, postcode_prefix char, filler2 char, postcode_range char, filler3 char, town char, filler4 char, county char, valid_date char) ********************************************************************** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ********************************************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).