troubleshooting Question

Need to do bulk export/import of BLOB data in Oracle 10g databases

Avatar of bergmanb
bergmanb asked on
Oracle Database
8 Comments2 Solutions6287 ViewsLast Modified:
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?

Thank you.
ASKER CERTIFIED SOLUTION
Rich Olu
Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros