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

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP!! ORA-00902: invalid datatype

Re: HELP!! ORA-00902: invalid datatype

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 05 Oct 2005 21:05:37 -0700
Message-ID: <1128571533.520817@yasure>


Vince wrote:
> Daniel or others,
>
> Is there an upper limit to worry about with the bulk fetch + related
> processing? Suppose the bulk fetch were 10M rows of about 10k of data
> each? In a case like that, I would probably still write as a cursor +
> loop.
>
> I realize that the answer may be machine dependant as far as SGA or
> memory is concerned, however it seems like there may be an upper limit
> to using the bulk methods.
>
> Vince

There is. And that is why the LIMIT clause exists.

My recollection is that array sizes of 100-250 records often gives the best results. Of course your mileage may vary.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Oct 05 2005 - 23:05:37 CDT

Original text of this message

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