Re: Fetch to copy tables by block

A copy of this was sent to Connor McDonald <connor_mcdonald_at_yahoo.com> (if that email address didn't require changing) On Thu, 16 Sep 1999 19:30:50 +0800, you wrote:

>
>Hello Thomas,
>
>In SQL Plus, 'arraysize' gives the nice "block fetch" for lack of a
>better term...
>
>Is this preserved across a database link ???
>

it (arraysize) is not used in the "INSERT INTO .. SELECT" statement. arraysize affects SQLPLUS operations only (not sql).

arraysize is good for SQL things only -- it works well with the COPY command in plus.

>Namely, is there any difference is issuing:
>
>set arraysize 100
>insert into table1
>select * from table2_at_other_site;
>
>versus
>
>set arraysize 5
>insert into table1
>select * from table2_at_other_site;
>
>(and ditto for create as select etc )
>
>Cheers
>Connor

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Sep 16 1999 - 13:50:46 CDT