Schema Compare for Oracle 6

Schema Compare for Oracle 6.0 release notes

Version 6.0.23 - May 30th, 2023


  • ZD-288195: Added support for VALIDATE_CONVERSION function
  • ZD-287529: Reorganize NOT NULL constraint handling to avoid scripting duplicate NOT NULL related constraints
  • ZD-282917: Resolved performance regression regarding dependencies

Version 6.0.22 - April 18th, 2023

Compatibility with Data Compare for Oracle 6.0.22

Version 6.0.21 - April 6th, 2023


  • ZD-281267: Fixed VALIDATE/NOVALIDATE on constraints not being detected as a difference in some situations and changed the way we script them to more accurately reflect how Oracle works
  • ZD-288195: Fix parsing error for certain usages of the COLLATE operator
  • ZD-286474: Prevents NOT NULL constraints on columns with custom types producing invalid constraints in scripts

Version 6.0.20 - March 22nd, 2023


  • ZD-282917: Added new comparison option "ignore lobs" that supersedes other options that include lobs

Version 6.0.19 - March 1st, 2023


  • ZD-285249: Prevents a situation where a token in a trigger body was incorrectly being handled as a schema name

Version 6.0.18 - February 14th, 2023

Compatibility with Data Compare for Oracle 6.0.18

Version 6.0.17 - December 21st, 2022


  • ZD-282684: Corrects identifying Queues when the user has permissions to access dba_queues but not dba_objects

Version 6.0.16 - November 22nd, 2022

Compatibility with Data Compare for Oracle 6.0.16

Version 6.0.15 - October 18th, 2022


  • Internal fix: Improved logging to assist in diagnosing issues around metadata access permissions

Version 6.0.14 - October 4th, 2022


  • ZD-278039: Corrects handling of the UNUSABLE property on primary key constraints

Version 6.0.13 - September 20th, 2022


  • ZD-277495: Fixed an error comparing a table partitioned on a LOB column with system-added partitions, when "ignore system partitions" is enabled.

Version 6.0.12 - August 16th, 2022

Compatibility with Data Compare for Oracle 6.0.12

Version 6.0.11 - August 10th, 2022


  • ZD-275713: Fixed issue with dependency ordering in some circumstances (in particular, FAST REFRESH materialised views).

Version 6.0.10 - August 2nd, 2022


  • ZD-275967: Fixed blank deployment script when materialized views differ solely by LOGGING / NOLOGGING.
  • ZD-275062: Command Line output now shows where a difference is included or not included. Also added a warning informing that only included differences will be deployed.

Version 6.0.9 - July 20th, 2022

Compatibility with Data Compare for Oracle 6.0.9

Version 6.0.8 - June 28th, 2022


  • OC-1341: Fixed reading comments on default values from scripts folders.

Version 6.0.7 - June 14th, 2022

Compatibility with Data Compare for Oracle 6.0.7

Version 6.0.6 - June 7th, 2022


  • ZD-271844 Fixed unexpected difference in lob columns with certain options set

Version 6.0.5 - May 26th, 2022


  • ER-63 ZD-260286 ZD-261904: Added support for automatic partitions

Version 6.0.4 - May 18th, 2022

Compatibility with Data Compare for Oracle 6.0.4

Version 6.0.3 - April 27th, 2022


  • ZD-268495: Fix parsing error for list partitions with multi-column values

Version 6.0.2 - March 24th, 2022


  • ZD-268503: Fixed error on comparison when user has access to dba_scheduler_jobs but not dba_scheduler_job_roles.

Version 6.0.1 - March 2nd, 2022

Compatibility with Data Compare for Oracle 6.0.1

Version 6.0.0 - February 24th, 2022

Compatibility with Data Compare for Oracle 6.0.0


Didn't find what you were looking for?