Moving BLOBs between databases
I need to retrieve rows containing BLOB's from a MySQL database and insert them into an Oracle 9i database. I have not worked with BLOB's before and am perplexed on how to resolve this problem.
Do I need to retrieve the the BLOB from the MySQL database, write it to a file, then read the file and insert it into the Oracle database?
I have worked with Oracle for several years but am new to MySQL.
Any advice would be greatly appreciated.
Jerry
Subject
Written By
Posted
Moving BLOBs between databases
May 03, 2005 09:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.