7 Replies Latest reply on Sep 18, 2012 11:15 PM by 955604

    OLE object Migration from Access to Oracle through SQL developer


      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?