Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 Mon Mar 11 2002 - 20:12:49 CST