Fetch to copy tables by block

From: <laurent_pele_at_my-deja.com>
Date: Thu, 16 Sep 1999 13:46:32 GMT
Message-ID: <7rqsbl$b3i$1@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 - 08:46:32 CDT