Re: Oracle 9.2.0.5 and sqlldr problems

Don Seiler <don_at_seiler.us> wrote in message news:<pan.2004.04.07.21.56.23.468242_at_seiler.us>...
> On Wed, 07 Apr 2004 12:17:38 -0700, Paul Drake wrote:
>
> > 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.
>
> By "client" do you mean the sqlldr client? If so it is the client on that
> server:
>
> SQL*Loader: Release 9.2.0.5.0 - Production on Wed Apr 7 16:56:36 2004

Don,

Patching the w2k pro client to 9.2.0.5 did not produce a fix. Its likely an end-of-file issue.
There are related postings on metalink forums. We're attempting a work-around by using an additional, explicit end-of-file marker.

Pd Received on Wed Apr 07 2004 - 23:47:02 CDT