Object Type Specific Options | Compare Storage Clause options do not reflect in the comparison of tables and in the Sync script of compare.
Schema Compare | Object Type Specific Options | Compare Storage Clause was selected and "Compare Analyzed" checkbox was unchecked. Under Storage Clause Options tab, all checkboxes were unchecked except for "Tablespace" checkbox. However, the comparison still compares storage clause parameters such as COMPRESS/NOCOMPRESS parameters and the Sync script also includes Alter statements to change these parameters of tables.
The only way to eliminate the COMPRESS/NOCOMPARESS parameter differences is to uncheck everything under "Storage Clause Options" or uncheck "Compare Storage Clause".
Sync script also includes Create statements that uses storage parameter clauses of the source destination instead of using Oracle default parameters when these options are unchecked under Storage Clause Options tab.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center