Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data type issue during migration

628927May 7 2008 — edited Aug 4 2009

Hello:

Our sqlserver some table fields have more than 8000 char. We use sqlserver datatype: ntext for those fields. When I captured those table, I got some warning: Column 'tableName'.'des' data type was transformed to CLOB as the default rule transformation resulted in an invalid data type.

Then I checked generated DDL. The migration tool changed sqlserver datatype: ntext to Oracle: nclob.

My question is that as we could not change original sqlserver datatype ntext because those information is huge, are those data still be migrated to oracle successfully based on Oracle datatype nclob?

Your help is highly appreciated.

Hal

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2009

Added on May 7 2008

#database-and-application-migrations, #from, #migration, #oracle, #server, #sql, #to, #with

12 comments

7,272 views