Re: strange sql*loader problem

From: Lee Parsons <lparsons_at_eskimo.com>
Date: 1995/07/18
Message-ID: <DBwEq9.6sn_at_eskimo.com>#1/1


Sheck Cho <skcho_at_ix.netcom.com> wrote:
>I invoke sql*loader and the log file shows the correct
>number of rows being loaded. However, select count(*)
>yields more rows than were actually loaded.

Are you using multiable WHENs in your control file? I have had this happen when a single record unexpectedly matched 2 WHENs

What does your control file and log look like?

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com
Received on Tue Jul 18 1995 - 00:00:00 CEST

Original text of this message