SQL Loader Log File Creation [message #334284] |
Wed, 16 July 2008 01:33  |
nmk_ora
Messages: 4 Registered: June 2008 Location: India
|
Junior Member |
|
|
Hi,
I have to load the data file(test.dat) into a table named "Test", data file(test.dat) contains 1278684 records.
Even though sql loader(with option direct=true) loaded the all 1278684 records into the table, but the log file created by the sql loader gives the information that it loaded only 1277988 records.
Below is the some of the information from log:
"1277988 Rows successfully loaded."
"0 Rows not loaded due to data errors."
"Total logical records read: 1278684"
when i removed the direct option then the log file created by sql loader is proper,as follows:
"1278684 Rows successfully loaded."
"0 Rows not loaded due to data errors."
"Total logical records read: 1278684"
can any one explain why the sql loader created log file with improper results in earlier(with option direct=true)?
Thanks in advance.
|
|
|
|
|
|
|
|
Re: SQL Loader Log File Creation [message #334850 is a reply to message #334284] |
Fri, 18 July 2008 06:21   |
nmk_ora
Messages: 4 Registered: June 2008 Location: India
|
Junior Member |
|
|
Hi Michel,
Table is standard one.
No partitions on table & it had local indexes
control file:
LOAD DATA
TRUNCATE
INTO TABLE Test
Fields terminated by "|"
TRAILING NULLCOLS
(
col1 "LTRIM(RTRIM(:col1,' '),' ')",
col2 "LTRIM(RTRIM(:col2,' '),' ')",
col3 "LTRIM(RTRIM(:col3,' '),' ')",
col4 "NVL(LTRIM(RTRIM(:col4)),NULL)"
)
|
|
|
|
Re: SQL Loader Log File Creation [message #334951 is a reply to message #334852] |
Fri, 18 July 2008 17:27  |
 |
Barbara Boehmer
Messages: 9104 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
Back in 9i, there were some things that happened out of order with the nvl function in SQL*Loader direct load that produced strange results. It would try to validate constraints and such prior to applying the nvl. Try eliminating the nvl function, since it is useless with a null value anyhow, and see what you get.
[Updated on: Fri, 18 July 2008 18:21] Report message to a moderator
|
|
|