This content has been marked as final. Show 7 replies
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.
Am working in the Oracle data integrator tool.
The migration is to be done is from DB2, sql server to Oracle 11g servers.
So have a confusion whether the BLOB/CLOB data will be loading for the bulk load and the incremental load.
Or do we have any challenges with loading the BLOB and CLOB data.
Please let me know if you require further information.
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: