"long raw" Data

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 5
Joined: Thu 08 Feb 2007 08:47

"long raw" Data

Post by cat_millenium » Sat 24 Feb 2007 11:58


I have one table in oracle and one on sqlce

create table ora
(i as integer,
dat as long raw)

create table sqlce
(i as integer,
dat as image)

Now I want to copy the records from ora into sqlce.
What is the best way to do this?



Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 26 Feb 2007 09:17

There is nothing quicker in Oracle then "select * from ora" with reader. In SqlCe there is also no acceleration technique we know. Just inserting in a loop.

Post Reply