Re: Oracle 9.2.0.5 and sqlldr problems

Don Seiler wrote:

> One of my developers just emailed me with the issue I've quoted below.
> The "upgrade" he mentions was the recent patch from Oracle 9.2.0.4 to
> 9.2.0.5. This is an x86 box running RHEL 3.0 ES. I've read a "horror
> stories" thread on 9.2.0.5. Should I consider downgrading the box back to
> 9.2.0.4 or should I encourage them to do some datafile checking before
> calling sqlldr to avoid this problem?
>
> BEGIN QUOTE
> We are having some problems with the sql loader problem. Before the
> upgrades, sql loader would run fine if we passed in an empty datafile.
> After the upgrade we get this error:
>
> SQL*Loader-961: Error calling once/load finishing for table
> RATE.CELLSITE_0040220
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01001: invalid cursor
> SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
> END QUOTE
Open an iTAR ... but my instinct would be ... back to 9.2.0.4.

Why are so many people installing software without vetting it on a test box?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)