Re: More: ORA-01013, "user requested cancel of current operation"

[Eric Dimick Eastman <erice@ONTKO.COM>]

Hello,

I posted a message about this exact problem a while ago and have had it
as an ongoing problem for the last year.  I get it while loading flat
files into Oracle.  There doesn't seem to be any rhyme or reason to it.
I have worked around this problem by making my load programs robust.
I have a on-error clause on each begin-sql and begin-select that prints
an error to a log file and puts the offending datafile lines in an error
file to be re-run.  I get that error about 1 record per 100,000.

I will continue to work on this problem, and if find anything out I
would love to hear it.

Thanks,
Eric

On Fri, 3 Jul 1998, jlwyant wrote:

> All,
>
> Thanks to everyone who has already responded.
>
> As I mentioned early I'm passing this message on for a friend... I have
> a few more details and now know that he did not press control-c or any
> other cancelling operation. I do know that he is loading flat files into
> Oracle. He has been able to load small tables with ten thousand records
> or less. It is the larger loads that appear to quit with the ORA-01013
> error. He informs me that after running the same SQR multiple times it
> never errors in the same procedure or record count. I suggested as a
> wild guess that he try issuing a commit after say 500 hundred inserts.
> My thinking here is the possibility of a full rollback segment.
>
> Thanks for all your help. Jim
>

------------------------------------------------------------------------
Eric Dimick Eastman  |Ray Ontko & Co | This space for rent.
erice@ontko.com      |Richmond, IN   | Your opinion here.
http://www.ontko.com |               |