7 Replies Latest reply: Sep 18, 2012 6:15 PM by 955604 RSS

    OLE object Migration from Access to Oracle through SQL developer

    938943
      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.