How do I migrate the Microsoft Access Memo columns in tables?
The Oracle ODBC driver automatically handles both BLOB and CLOB columns. By default, all Microsoft Access Memo fields are mapped to CLOB datatypes in an Oracle database. You can use the Microsoft Access front end with the destination Oracle database. Unlike LONG columns, from Oracle 8.x onwards you can have any number of LOB columns in a table. You can have either internal LOBs, meaning they are inside the database, or external LOBs, meaning they are in a file on the file system but under the database’s transactional control. The advantages of LOBs are that you can replicate them or index them using the context option.
