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.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center