Hi all,

I have one table in Access and that needs to be migrated over to Oracle. this table had two columns ( one is text and the other one is MEMO) and the MEMO field had a lot of character( more than 4000 characters one some of the rows). So I created a table in Oracle with one columns is varchar2(4000) and the other columns is LONG datatype.

I insert the data from Access to Oracle using ODBC, the data migrated over to Oracle; HOWEVER, some of the data was cut off in some rows. I don't know what happen.

Can someone tell me what happened here ???