This content has been marked as final. Show 3 replies
are both tables table1 and table2 linked tables, or is one them still a local table in Access? How were the column types of these tables before the migration, and how are the column types of the migrated tables in Oracle?
I googled a little bit for the error message and got some hits with the same issue, but found no solution.
Both tables are now linked.
table1.column - text
table2.colum - note
table1.column - varchar2(50bytes)
table2.column - varchar2(50bytes)
What are your versions of Oracle, MS Access and SQL Developer?1 person found this helpful
I don't know the type "note" in MS Access, my version of Access is 2000 and let me create a field of type Memo but not a field of type Note. Is that the same, my Access knowledge is not so deep?
A text field is converted to varchar2(50 char), and a memo field is converted to CLOB, but that depends on the charset setting of the Oracle database, mine is UTF8, and yours?