I'm migrating an Access 2007 DB to Oracle 126.96.36.199.
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?
The problem is that the data type attachment is just a reference to an object that is stored somewhere else. There's currently no support in SQL Developer to properly migrate this kind of table with an attachment data type - see also the documentation for MS Access databases:http://docs.oracle.com/cd/E25259_01/doc.31/e18459.pdf
I've created an enhancement request to improve the functionality.
Edited by: kgronau on Dec 5, 2012 8:54 AM
Tracking# for the ER: 15957632