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

[jlwyant <jlwyant@ACM.ORG>]

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