Re: Oracle 9.2.0.5 and sqlldr problems

drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0404072047.20c2b658_at_posting.google.com>...
> 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

a test case in a 10.1 database (winXP Pro, laptop) did not (re)produce the problem. might just move development to 10.1, might request the fix backported to 9.2.0.x.

Pd Received on Fri Apr 09 2004 - 19:15:05 CDT