Schema Compare for Oracle Releases

Released: Feb 3, 2026

Updates in 6.3.52

Fehlerkorrekturen

  • Ignore columns with names that start with "CDRTS$". Relevant to Oracle Golden Gate generated columns.

Released: Jan 20, 2026

Updates in 6.3.51

Funktionen

  • Added deeper support for JSON_VALUE syntax including ALLOW TO NUMBER CONVERSION.
  • Added support for tracking segment name for Lob storage in comparison and script generation.

Fehlerkorrekturen

  • Fixed unexpected difference in XMLType columns with include storage options set.
  • Fixed an issue with nested table types where under certain scenarios they were not being populated correctly.
  • Fixed invalid SQL in deployment script when modifying storage options of an XMLType column.
  • Fixed an issue...

Released: Dec 18, 2025

Updates in 6.3.49

Funktionen

  • Improved parser support for the "JSON_value_return_type"-clause syntax of the JSON_VALUE function.
  • Added support in the CLI for the new "index-related primary key construction differences" option.

Fehlerkorrekturen

  • Fixed an issue where the tablespace property on XML_Type storage was not being generated correctly in some scenarios when deploying to a scripts folder.
  • Permissions on SCHEDULER JOB objects are now scripted out correctly.

Released: Nov 18, 2025

Updates in 6.3.48

Fehlerkorrekturen

  • Fixed an issue where Time Zone information was not being respected for schedule objects.

Released: Nov 18, 2025

Updates in 6.3.47

Funktionen

  • Added a comparison option to treat primary key constraints the same as those created by unique indexes.

Fehlerkorrekturen

  • Fixed an issue where the engine incorrectly formats a script that exceeds the 2499 characters limit for a single line in SQL*Plus.
  • Fixed an issue where the engine failed to parse GRANT statements with DEBUG CONNECT privileges when reading from a scripts folder.

Released: Aug 8, 2023

Updates in 6.1.x

v6.1.0

Updated Aug 8, 2023

Features

  • Added support for time based Schedule objects.

Released: Feb 24, 2022

Updates in 6.0.x

v6.0.23

Updated May 30, 2023

Features

  • Added support for VALIDATE_CONVERSION function.

Fixes

  • Reorganized NOT NULL constraint handling to avoid scripting duplicate NOT NULL related constraints.
  • Resolved performance regression regarding dependencies.

v6.0.22

Updated Apr 18, 2023

Features

  • Compatibility with Data Compare for Oracle 6.0.22.

v6.0.21

Updated Apr 6, 2023

Fixes

  • Fixed VALIDATE/NOVALIDATE on constraints not being detected as a difference in some situations and changed the way you script...

Released: Feb 4, 2020

Updates in 5.7.x

v5.7.31

Updated Jan 18, 2022

Fixes

  • Materialized view logs and indexes are recreated when their underlying objects and dropped and rebuilt.
  • Fixed spurious difference when comparing a scripts folder containing a table with a not null column with a user-defined type.

v5.7.30

Updated Jan 12, 2022

Fixes

  • SQL constraints like CHECK (columname IS JSON (STRICT WITH UNIQUE KEYS)) (with inner brackets) are handled correctly.

v5.7.29

Updated Dec 22, 2021

Fixes

  • Objects in the SYS schema marked as ORACLE...

Released: Oct 2, 2019

Updates in 5.6.x

5.6.4

Updated Jan 7, 2020

Features

  • Information about used ignore rules added to application log file.

Fixes

  • OC-1123: Issue causing an error "not set instance of an object" when creating deployment script for organization index table with partitions fixed.
  • OC-1180: Problem with parsing "interval" keyword in materialized view with range partitioning fixed.
  • OC-1174: Issue when grants are not included in deployment process despite being selected for deployment fixed.
  • OC-1156: Problem with scripting...

Released: Aug 20, 2019

Updates in 5.4.1

Updates in 5.4.1

  • Allows using Service Name for manual connection to Oracle databases.