I am working on Sybase to Oracle 11g data migration project.
We have clob data in tables exported from Sybase in text files.
We want to load Clob data to Oracle through SQL Loader.
Please let me know how we can load through SQL Loader or any other method.
You can have SQL Developer setup your sqlldr session using the import data feature. I've described it in more detail here.