Re: sql loader log file problem

[Tanel Poder]

Title: Message

Hi!   You probably have 8842 separate rows in your input text file. But your sqlloader knows how to extract several database records from one physical text file row, depending on your controlfile. Thus, in some cases it makes multiple records out of single row and here comes the difference.   Tanel. ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 10, 2003 8:24 AM Subject: sql loader log file problem Hi All,           the sql loader log file is giving the o/p as :     8842 Rows successfully loaded.   0 Rows not loaded due to data errors.   0 Rows not loaded because all WHEN clauses were failed.   0 Rows not loaded because all fields were null.   Total logical records skipped:          0 Total logical records read:          9488 Total logical records rejected:         0 Total logical records discarded:        0    But the records loaded in the table is 9488 instead of 8842.  is this an error in log file o/p.  can such problem be possible in sql loader.    also this is the first time I am getting such different o/p when there are no rejected and discarded.  can anyone explain this.     Thanks Manoj