Re: SQL*Loaders terminate inexplicably

On Thu, 27 Jun 2002 14:17:39 GMT, Mark Styles <news_at_lambic.co.uk> wrote:

>On Thu, 27 Jun 2002 19:34:26 +0530, "Yash R. Ganthe"
><yash_ganthe_at_hotmail.com> wrote:
>>After running for a long time, the sql loaders terminated suddenly one after
>>another. The following message was shown in the log file of each of these
>>sql loaders:
>>
>>Error shipping index to read buffer across 2-task
>>ORA-01013: user requested cancel of current operation
>
>The message suggests that somebody killed the processes. Is there a
>DBA around there somewhere who doesn't like long running jobs?

Or do you have a profile that sets a limit on resources. Max CPU per request, IO limit or other constraint that would cause the load to be terminate on resource exceeded? Received on Fri Jun 28 2002 - 00:43:54 CEST