Re: Oracle 9.2.0.5 and sqlldr problems

Don Seiler <don_at_seiler.us> wrote in message news:<pan.2004.04.07.13.52.35.675406_at_seiler.us>...
> On Tue, 06 Apr 2004 15:41:53 +0000, Don Seiler wrote:
>
> > One of my developers just emailed me with the issue I've quoted below.
>
> My developers are also having a problem where sqlldr leaves the PK indexes
> in an unusable state with 9.2.0.5. Rebuilding the indexes fixes the
> problem, and I'm having the devs just issue the rebuild command at the end
> of their script.
>
> Has anyone seen anything like this with 9.2.0.5?
>
> Methinks with our main database I'll be holding steady at 9.2.0.4 when I
> migrate from 7.3.4.5.

Don,

We hit this today, as I had applied 9.2.0.5 against a db running RHEL 3.0 ES.
The client was running 9.2.0.4 (W2K Pro, SP4). I've applied the 9.2.0.5 patchset on that desktop, and awaiting his return from lunch to re-run the load.

from the trace file out of /udump, sqlldr was attemping to insert a row of entirely NULL characters, using DIRECT load.

I believe that we have hit the exact same error.

what version of the Oracle client are you using? feel free to contact me offline.

Paul Received on Wed Apr 07 2004 - 14:17:38 CDT