Re: Fetch to copy tables by block

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 16 Sep 1999 15:34:12 +0100
Message-ID: <937493558.14618.0.nnrp-02.9e984b29@news.demon.co.uk>

Which version of Oracle ?
It affects the possibilities.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

laurent_pele_at_my-deja.com wrote in message <7rqsbl$b3i$1_at_nnrp1.deja.com>...
>Hello everybody
>
>I want to copy a table into another one by blocks of 1000 rows to avoid
>exceeding the rollback segments size.
>
>I know how I can do that with Sybase : I write a stored procedure
>with a loop that fetch a group of 1000 rows but I haven't found the
>equivalent with Oracle.
>
>Can anybody may be of any help ?
>Thank you
>
>--
>Laurent PELE
>13 rue Lantiez 75017 Paris
>mailto:laurent_at_pele.org
>Currency converter on http://195583.com
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Sep 16 1999 - 09:34:12 CDT