Trang, I had a similar problem a while back and the answer was to have the clause "TERMINATED BY WHITESPACES" as the option for the last column. Yours continues to the next line because of the termination and enclosed clause. You might be confusing the load by saying it is TERMINATED BY and ENCLOSED BY, Which is it? Ron ROR m���m
>>> [EMAIL PROTECTED] 04/18/02 03:49PM >>> Meomeo Nguyen <[EMAIL PROTECTED]> wrote: Hi List, Below are my control and data files:(both files are stored on /Disk05) terminal.ctl file: LOAD DATA INFILE = 'Disk05/terminal.dat' INTO TABLE TERMINAL_POSITION FIELDS TERMINATED BY ',' ENCLOSED BY '"' ( TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY "," ENCLOSED BY '"', TERMINAL_POSITION_NAME VARCHAR2 TERMINATED BY "," ENCLOSED BY '"', TERMINAL_POSITION_DESCRIPTION VARCHAR2 TERMINATED BY "," ENCLOSED BY '"' ) terminal.dat file: A,Axial,Terminals extend from both ends in the direction of the major axis of a cylindrical or elliptical package. B,Bottom,Terminals extend from the bottom of the package. D,Dual,Terminals are on opposite sides of a square or rectangular package or located in two parallel rows. for any reason, when entering sqlldr username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log data = '/Disk05/terminal.dat' an error message shows: segmentation fault. Alternatively, when issuing sqlldr userid = username/password control = /Disk05/terminal.ctl log =/Disk05/terminal.log data = '/Disk05/terminal.dat' an error message shows: lf iopn failed for file (terminal.log) Please note that: I did create terminal.log that is stored on /Disk05 as well. Please anyone point out what did I do wrong. Your help is greatly appreciated. Thanks Trang --------------------------------- Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax --------------------------------- Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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).
