Does anyone have experience migrating data from Sybase to Oracle using bcp and SQL Loader? I can migrate text data without any problems using bcp character format. I can also migrate image data using bcp native format. The problem is when I need to have text data and image data in the same export files. I can't have the text readable and the images in RAW format so they can be loaded by SQL Loader.
Perhaps you'd want to check Oracle Migration Workbench; on that page, you'll find a link to Oracle SQL Developer GUI utility which incorporates migration workbench for several databases, including Sybase.
I didn't do it, but you might read through the documentation and see whether it offers an easy (easier) way to migrate your data than by using SQL*Loader.