SQL*Loader question. Need a quick answer. Please

2002-04-18 Thread Meomeo Nguyen
  Meomeo Nguyen <[EMAIL PROTECTED]> wrote: Hi List,Below are my control and data files:(both files are stored on /Disk05)terminal.ctl file:LOAD DATAINFILE = ‘Disk05/terminal.dat’INTO TABLE TERMINAL_POSITIONFIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”’(TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY “,” E

Re: SQL*Loader question. Need a quick answer. Please

2002-04-18 Thread Ron Rogers
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 ENCL

RV: SQL*Loader question. Need a quick answer. Please

2002-04-18 Thread Natalia Laracca
username/password control =/.../terminal.ctl errors=50 bad =/./terminal.bad log =/../terminal.log     Natalia L. Laracca   - Original Message - From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Thursday, April 18, 2002 4:49 PM Subject: SQL*Loader ques

Re: RV: SQL*Loader question. Need a quick answer. Please

2002-04-18 Thread Meomeo Nguyen
inal.log     Natalia L. Laracca   - Original Message - From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Thursday, April 18, 2002 4:49 PM Subject: SQL*Loader question. Need a quick answer. Please   Meomeo Nguyen <[EMAIL PROTECTED]> wrote: Hi List,Below are my control