Conversion DB Access to ORACLE

Fermé
ple - 4 févr. 2008 à 14:19
phil_232 Messages postés 286 Date d'inscription jeudi 6 décembre 2007 Statut Membre Dernière intervention 12 juin 2008 - 4 févr. 2008 à 20:02
Hi,
I need some tool to convert a ACCESS DB to an ORACLE DB.

1) I have a table with a field of type ‘OLE Object” which I want to convert into a Oracle table in a BLOB field.
Is it possible to to this or do I have to pass by a transition table with a long raw field ?

2) I have a table with a field of type “Hypertext Link” which links a JPG file. Can you propose me the way to inserts them in a new table with a blob field ?

Thank you for your help.

1 réponse

phil_232 Messages postés 286 Date d'inscription jeudi 6 décembre 2007 Statut Membre Dernière intervention 12 juin 2008 33
4 févr. 2008 à 20:02
hypertext links are a functionality of Access. there is no such thing in Oracle. is there a pb transferring the OLE Object field to a BLOB? in fact it should rather correspond to a raw or image field.
0