This discussion is archived
7 Replies Latest reply: Sep 18, 2012 4:15 PM by 955604 RSS

OLE object Migration from Access to Oracle through SQL developer

938943 Newbie
Currently Being Moderated
Hello,

I used sql developer 3.1.07(oracle 11g) to perform data migration from MS ACESS.
the MS access data has a column with data type as "OLE object" ---there
saved a lot of pdf files .

Then I performed "copy to oracle" from MS access connection, the OLE data
changed to BLOB from oracle database, and data seems to be copied to
database as binary . However none of the data in the column can be opened. I
download the blob data to a file from sql developer and tried to open
using Adobe 8.1 with no success.

How can I fix this issue? or I should say, how can I migrate MS access OLE data to oracle?

Thanks,

H.M.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points