could not import for table having varchar column length greater than 4000
MoazzamApr 7 2009 — edited Apr 7 2009I 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