I work for a cruise line and our databases are developed in our corporate IT office before deploying them out to our ships. We have personnel that have their photo embedded within the Oracle 10g database as BLOB data. There are about 258 records that we need to export the BLOB data for and then import that data into the 10g database on each ship. We already do bulk exports/imports of the text data but now our new directive is to push the corresponding photos with them.
Using TOAD we can extract one BLOB object at a time but we need to find an application (or script) that will allow us to do this in bulk - quickly and efficiently - and then do the bulk import of the same data to each of the other Oracle 10g databases we have.
Would anyone have any suggestions?