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
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
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
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.datINTO TABLE TERMINAL_POSITIONFIELDS TERMINATED BY , ENCLOSED BY (TERMINAL_POSITION_ID VARCHAR2 TERMINATED BY , E