Home » RDBMS Server » Server Utilities » SQL Loader Log File Creation
SQL Loader Log File Creation [message #334284] Wed, 16 July 2008 01:33 Go to next message
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 #334307 is a reply to message #334284] Wed, 16 July 2008 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without any other information, the answer is no.

Post your control and log files.

Regards
Michel
Re: SQL Loader Log File Creation [message #334809 is a reply to message #334307] Fri, 18 July 2008 02:58 Go to previous messageGo to next message
nmk_ora
Messages: 4
Registered: June 2008
Location: India
Junior Member
Sorry i attached wrong file
please find the correct one
Re: SQL Loader Log File Creation [message #334810 is a reply to message #334307] Fri, 18 July 2008 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is the table a standard one? IOT? cluster?...
Is the table partitioned?
Do you have local or global indexes?
Is there any thing different in the lines that are not in the table?

By the way, the purpose of NVL is to give a value to NULL, if you give it NULL is it useless (see last field).

Regards
Michel
Re: SQL Loader Log File Creation [message #334813 is a reply to message #334809] Fri, 18 July 2008 03:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please repost the control file, someone delete the whole post instead of just the attached file.

Regards
Michel
Re: SQL Loader Log File Creation [message #334822 is a reply to message #334813] Fri, 18 July 2008 04:15 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm, it was me; the report said "delete message #334808". Sorry, I should have been careful.
Re: SQL Loader Log File Creation [message #334850 is a reply to message #334284] Fri, 18 July 2008 06:21 Go to previous messageGo to next message
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 #334852 is a reply to message #334850] Fri, 18 July 2008 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any thing different in the lines that are not in the table?

Regards
Michel
Re: SQL Loader Log File Creation [message #334951 is a reply to message #334852] Fri, 18 July 2008 17:27 Go to previous message
Barbara Boehmer
Messages: 8636
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

Previous Topic: I need to import execl to oracle - HAve a free software?
Next Topic: problem with export
Goto Forum:
  


Current Time: Fri Dec 09 09:47:24 CST 2016

Total time taken to generate the page: 0.06073 seconds