Re: SQL*Loader and Mutating Table

A copy of this was sent to buckeye714_at_my-deja.com (if that email address didn't require changing) On Mon, 24 Jan 2000 21:24:37 GMT, you wrote:

>If anyone could help, I would really appreciate it. I am experiencing
>some trouble with SQL*Loader, though I am not sure it is a SQL*Loader
>problem. I am using Oracle 8.0.5 on a Solaris box. I am using a script
>written by a consultant to load data into the Database. I am using the
>following command:
>sqlldr userid=user/password_at_instance control=foobar.ctl rows=1
>After 5048 records have loaded I get the follwing error message:
>
>Record 5049: Rejected - Error on table LTRK_APPLICATIONS.
>ORA-04091: table SYS.UET$ is mutating, trigger/function may not see it
>ORA-06512: at "EVT.LTRK", line 191
>ORA-06512: at "EVT.CG$AIS_LTRK_APPLICATIONS", line 17
>ORA-04088: error during execution of trigger
>'EVT.CG$AIS_LTRK_APPLICATIONS'
> I get this message for the next 50 records, at which point I have
>reached the maximum number of errors has been reached. Does anyone have
>any ideas on why this happens or how to fix. Thanks in advance.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

There is an issue with triggers on insert that do lots of inserts themselves that cause lots of space management requests.

A potential solution is to preallocate the space in the tables -- to reduce the amount of recursive space requests being made or to increase the next extent size (to achieve the same goal). that'll get you going today.

The permanent solution is to contact support and reference bug 697443. there is a patch.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jan 25 2000 - 07:46:34 CST