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: Failed Import

Re: Failed Import

From: <holmesb_at_my-dejanews.com>
Date: Mon, 14 Dec 1998 21:17:03 GMT
Message-ID: <753v8c$kqp$1@nnrp1.dejanews.com>


In article <36744CC5.B5010CE_at_home.com>,   Mike <mminamoto_at_home.com> wrote:
> I was importing an export file from one db to another when the import
> failed out on a coloum size error...
>
> After looking at the error in oerr and experimenting a bit I increased
> the buffer size of the import and all went well...
>
> The thing is I am unsure why this worked, and would like to know.
> I suspect that the entire table and/or coloum must be read into
> memory before import but ?????????? Any comments would be greatly
> appreciated...
> --
> Please remove ".nojunkmail" from my
> address before replying............
>

Probably a column of datatype LONG or not changing the default buffer size.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 14 1998 - 15:17:03 CST

Original text of this message

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