Re: Oracle Block copy of table

You can retrieve multiple rows at a time via the array interface. Via the same interface you can insert multiple rows at the same time. There are limits as to how many rows; if the table is gigabytes in size would you really want to deal with the whole thing all at once?

If your question is really how do I read and write raw database blocks myself and not go through Oracle then no; there is no published mechanism. Jim
"Noel P" <noelp1_at_hotmail.com> wrote in message news:530e4840.0203111624.622112ca_at_posting.google.com...
> Hi,
>
> I am using OCI or ODBC to access to the Oracle database.
> Is there a way in Oracle (or support in OCI or ODBC) to extract the
> entire table into memory with one call.
> Also, do the same for wtiting to the table.
>
> Thank you,
>
> -Noel.
Received on Tue Mar 12 2002 - 03:12:49 CET