Re: How to: Copy LONG field from one table to another

Thomas,

Thanks for the tip.

If I may ask another question: How does one find out how long the longest LONG is?

Thomas Kyte wrote:

>
> You'll want to set
>
> set arraysize N -- amount of rows the copy command will copy with each fetch
> set long N -- size of your longest long
> set copycommit M -- number of fetches to do before commit (N*M rows!!)
>
> in plus before doing this. see the manual for all the options....
>
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Service Industries
> Reston, VA USA
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> Anti-Anti Spam Msg: if you want an answer emailed to you,
> you have to make it easy to get email to you. Any bounced
> email will be treated the same way i treat SPAM-- I delete it.

--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514 Received on Wed Feb 03 1999 - 12:34:46 CST