Schema Compare has an option to use DBMS_REDEFINITION to modify column datatypes. In some cases, this is the only way to change a column datatype (for example from VARCHAR2 to CLOB) without dropping and recreating the table.
However, the option does not work unless a similar option "Add/Reorder columns with DBMS_REDEFINITION" is also checked.
