Schema Compare option to use DBMS_REDEFINITION to modify column datatypes doesn't work unless the option "Add/Reorder columns with DBMS

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Schema Compare option to use DBMS_REDEFINITION to modify column datatypes doesn't work unless the option "Add/Reorder columns with DBMS_REDEFINITION" is also checked. (4378269)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Schema Compare option to use DBMS_REDEFINITION to modify column datatypes doesn't work unless the option "Add/Reorder columns with DBMS_REDEFINITION" is also checked.
Description

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.
Resolution

WORKAROUND:
None

STATUS:
Waiting for fix in a future release of Toad for Oracle.
Defect ID

TOR-8889

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Schema Compare option to use DBMS_REDEFINITION to modify column datatypes doesn't work unless the option "Add/Reorder columns with DBMS_REDEFINITION" is also checked. (4378269)

Title

Description

Resolution

Defect ID

Leave a Comment