Return
-
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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.