Re: Oracle 9.2.0.5 and sqlldr problems

Don Seiler <don_at_seiler.us> wrote in message news:<pan.2004.04.06.15.48.18.114073_at_seiler.us>...
> 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
Don,

so the load aborted due to an empty datafile? sounds like the intended behavior to me.

you must have had some reason for applying the 9.2.0.5 patchset (bugfix perhaps?). those reasons would not be invalidated by the behavior you describe above.

how about including a 'contents of datafile check' in your shell script prior to calling sqlldr? In the datafile check, skip to "BEGINDATA". If there is not a sufficient number of lines in the file after that string, abort and send an email.

my vote is for not downgrading.

an aside, did you update RHEL 3.0 ES via the Update 1 release, or leave it at the base release?

thanks,

Pd Received on Wed Apr 07 2004 - 01:18:30 CDT