This discussion is archived
2 Replies Latest reply: Feb 5, 2013 10:00 AM by elvegaa_esp RSS

Migrate Access 2007 with Attachtment fields to Oracle 11g issue

elvegaa_esp Newbie
Currently Being Moderated
Hi.

I'm migrating an Access 2007 DB to Oracle 11.2.0.2.
I'm using SQL Developer 3.2, but I dont know how to export a table wich contains an Attachment field column (wich are images).
With "Copy to Oracle" it converts it to a CLOB column, but it only store the filename.
The I tried with the "Microsoft Access 2007 exporter" and migration wizard to try it in Offline mode. The problem is when export the data with MS Access exporter.
It doesnt export any data. When the exporter finish it prompts me "Error #13: Type Mismatch"

How can I migrate a table like this? Is there any possible way to export the Attachment field images into a CLOB column?


Regards.

Legend

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