RE: Inserting long columns
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <jifjif@xxxxxxxxx>, <denise@xxxxxxxxxxxxxx>, "'Oracle-L@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 Jun 2013 23:17:03 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of ~Jeff~
Sent: Thursday, June 27, 2013 7:45 PM
To: denise@xxxxxxxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx> 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?
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
