Sync script for Object Compare (Schema) is doing a DROP TABLE instead of ALTER TABLE where the only difference is in the COMPRESS clause of the table (4306510)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Sync script for Object Compare (Schema) is doing a DROP TABLE instead of ALTER TABLE where the only difference is in the COMPRESS clause of the table
Description

When doing an Object Compare of a full Schema, some tables are showing as being different only in terms of the COMPRESS clause i.e.
one table shows COMPRESS YES ADAPTIVE and the other table shows COMPRESS YES STATIC
When the sync script is generated, Toad is doing a DROP and reCREATE of the table, when an ALTER table would suffice.
Resolution

WORKAROUND
none
STATUS
Waiting for fix in a future release of Toad for DB2 LUW
Defect ID

TDB-1740

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

Sync script for Object Compare (Schema) is doing a DROP TABLE instead of ALTER TABLE where the only difference is in the COMPRESS clause of the table (4306510)

Title

Description

Resolution

Defect ID

Leave a Comment