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!

SQL server to Oracle

860250Jul 12 2012 — edited Jul 13 2012

Hi,

I am trying to convert TEXT Type of sqlserver to Oracle. In oracle createad a field of type CLOB.

When I try to insert the same data from sqlserver Text type field to Oracle for CLOB type. It's not working as length of string is 31538.

Please suugest a datatype in Oracle which can hold SQL server Text datafield data.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2012

Added on Jul 12 2012

#database-and-application-migrations

5 comments

587 views