It would help to reply if you could also let us know what database platform you are migration to Oracle from. ie.. SQL Server, DB2, MySQL, etc... as the functionality and support of various types of data depend largely on the database being migrated via SQL Developer's Migration tool.
Apologies for the confusion. You are NOT migrating from a 3rd party database, such as SQL Server, Sybase, Informix, or alike to Oracle? You are migrating from Oracle to Oracle? Is this a database version upgrade then?
Thank you for the update. In think some further clarification may be helpful. This particular forum section is for SQL Developer's feature which is used to migrate from non-oracle databases to Oracle. If you are migrating from DB2 or SQL Server, and are concerned with how BLOB / CLOB data is handled for the migration, you are in the right place. However, the added component in your update which indicates Oracle as a source leaves some doubt as to weather your effort is to migrate TO Oracle from 3rd party databases. Please clarify the scope of your intention and the specific Oracle product you are using for which this question is posted.
Thank you for the update. I belive that the confusion is because you have updated the form that is specific to the SQL Developer tool's Migration function which is designed to port/convert non-Oracle databases to Oracle. For the Oracle Data Integrator, there is likely another forum for that.
Please try to post your question on the forum located here: Data Integrator