Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger fails under SQL*Loader

Re: Trigger fails under SQL*Loader

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 15 Nov 2004 18:32:51 -0800
Message-ID: <1100572289.724705@yasure>


Ramon F Herrera wrote:

> After reading some of the NG archives, I would like
> to add this to my own posting:
>
> Perhaps the problem I am having is related to the
> "infamous mutating table". That problem is supposed
> to be solved by a "rows=1" parameter in the .clt file.
>
> Another possibility is the direct path vs. conventional
> path load (I am not too familiar with the differences
> among them or how to change them)?
>
> -Ramon

If mutating table error you would have an error message that says just that. Likely it is the direct path issue which one resolves by reading the instructions for SQL*Loader.

http://tahiti.oracle.com

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 15 2004 - 20:32:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US