RE: Inserting long columns

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 27 Jun 2013 23:17:03 -0400
Message-ID: <052d01ce73ad$f708d250$e51a76f0$_at_rsiz.com>

Do be certain to set the LONG sqlplus parameter to at least the length of your longest long value (if you set it to less you are telling Oracle to silently truncate longer values). If memory serves the default is 80 and that is probably *NOT* what you want.

Some experimentation with the settings of arraysize and copycommit are also in order if you need to optimize the throughput.

I'd take a swipe at 512 and 4 and then maybe 1024 and 4, etc., (keep going if it keeps getting better, stop if you reach a plateau, avoid CTD).

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ~Jeff~
Sent: Thursday, June 27, 2013 7:45 PM
To: denise_at_mail.wvnet.edu; Oracle-L_at_freelists.org Subject: Re: Inserting long columns

Hi Denise,
the COPY TABLE syntax works for LONG
datatypes.<http://docs.oracle.com/cd/B10500_01/server.920/a90842/apb.htm> http://docs.oracle.com/cd/E11882_01/server.112/e16604/apb.htm

cheers,
Jeff

On 28 June 2013 04:09, Denise Gwinn <denise_at_mail.wvnet.edu> wrote:

> I have to merge some tables that contain a long datatype. A simple
> insert into tableA (select * from tableB) will not work. I've tried
> Googling, but not having much success. Could someone enlighten me please?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 28 2013 - 05:17:03 CEST