Skip to Main Content

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!

could not import for table having varchar column length greater than 4000

MoazzamApr 7 2009 — edited Apr 7 2009
I have installed Oracle 10g on Red Hat Linux machine.

I am trying to import data from SqlServer to my oracle database using Oracle Gateway for SqlServer.

I have a problem that when while importing data, if there comes a SqlSever table having column of type varchar(max) or varchar column length > 4000, then import statement is failed.

Can any body please tell me how to fix this issue.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2009
Added on Apr 7 2009
2 comments
3,388 views