When a table has data that includes a CLOB/BLOB column,
the copy operation fails (unknown column type). The
root problem is that the Oracle JDBC driver reports
CLOB/BLOB columns to have type 1111 (OTHER), when
it should report them as java.sql.Types.BLOB/CLOB
(2004/2005). There is already code to work-around
this problem, but it only addresses the scenario
where Oracle is the source database. If Oracle is
the destination database and the field type is
BLOB/CLOB the copy operation will fail.
Log in to post a comment.