Re: SQL*Loader not inserting all data

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Thu, 08 Jul 2004 15:31:02 -0500
Message-ID: <lnbre0pqq37qee1nnmdq5ofnk1i5k1esa9@4ax.com>

marc.petrivelli_at_sensis.com (Marc Petrive) wrote:

>Oracle 9.2.0.1
>Debian 3.0
>
>
>I have a SQL*Loader control file that contains the control information
>as well as the data. There are about 12M rows of data yet only about
>2M them make it into the database. I checked the BAD file that I
>specify in the control file and it only has a couple of rows in it. I
>am using the DIRECT=true flag in an attempt to speed the insert of
>data. Any idea what I might be doing wrong?

What does the LOG file say? Received on Thu Jul 08 2004 - 15:31:02 CDT