Schema Compare for Oracle 6.3 release notes
Published 16 January 2024
Version 6.3.43 - September 2nd, 2025
Features
- Adding or dropping range partitions on a table (but not both at once) no longer causes a table rebuild.
Version 6.3.42 - August 19th, 2025
Features
- Certain table and partitioned table rebuild scenarios in deployment scripts will use a Create Table As Select (CTAS) approach.
Fixes
- ZD-334351: Fix "An item with the same key has already been added" when deploying a constraint with an existing backing index and source/target schemas are identical
Version 6.3.41 - August 11th, 2025
Features
- Internal library updates
Version 6.3.40 - August 6th, 2025
Fixes
- ZD-335107: Fixed an issue where the engine incorrectly reported a difference for a Schedule where start_date, end_date or repeat_interval were null
Version 6.3.39 - July 22nd, 2025
Features
- Added a warning indicating that support for Oracle 11G and 11G2 will be dropped in a future version of Schema Compare for Oracle.
Version 6.3.38 - July 10th, 2025
Features
- Altering certain list partition properties no longer causes a table rebuild.
Fixes
- ZD-307891: Fixed an issue where the engine creates a duplicate unique index when referencing an invisible column with unique constraint
Version 6.3.37 - July 1st, 2025
Fixes
- ZD-333164: Don't generate SQL for system generated partitions when using the Ignore System Partitions option
Version 6.3.36 - June 17th, 2025
Features
- Internal library updates
Version 6.3.35 - June 13th, 2025
Fixes
- ZD-333164: Fixed an issue where invalid SQL was generated for table partitions when using the Ignore System Partitions option
Version 6.3.34 - June 10th, 2025
(Note: this release has been pulled)
Features
- Dropping list partitions on a table, when not adding or altering other partitions on it, no longer causes a table rebuild.
Version 6.3.33 - June 3rd, 2025
Features
- Adding list partitions on a table, when not dropping or altering other partitions on it, no longer causes a table rebuild.
Version 6.3.32 - May 27th, 2025
Features
- Added support for handling BINARY XML storage type
Fixes
- ZD-327929: Fixed an issue around showing "CLOB" instead of "BINARY XML" in the diff window
Version 6.3.31 - May 21st, 2025
Features
- Internal library updates
Version 6.3.30 - May 12th, 2025
Features
- Internal library updates
Version 6.3.29 - May 1st, 2025
Features
- Internal library updates
Version 6.3.28 - April 17th, 2025
Features
- Internal library updates
Version 6.3.27 - April 8th, 2025
Features
- Internal library updates
Version 6.3.26 - March 25th, 2025
Features
- Internal library updates
Version 6.3.25 - March 11th, 2025
Features
- Internal library updates
Version 6.3.24 - February 24th, 2025
Features
- Internal library updates
Version 6.3.23 - February 6th, 2025
Fixes
- ZD-318165: Changed encoding so the scripts folder now stores unescaped characters
Version 6.3.22 - January 28th, 2025
Fixes
- ZD-316728: Fixed issue where we were attempting to drop indexes that shared a name with a constraint but were created manually
- ZD-311607: Fixed issue where package names in trigger text was not scripted correctly when used with public synonyms causing a difference after deployment
Version 6.3.21 - January 22nd, 2025
Features
- Internal library updates
Version 6.3.20 - January 14th, 2025
Features
- Internal library updates
Version 6.3.19 - January 7th, 2025
Fixes
- ZD-307699: Fixed issue where primary key was attempting to be dropped from a materialized view without a primary key
Version 6.3.18 - December 17th, 2024
Fixes
- ZD-318479: Fixed issue where differences were being caused by use of SQL Keywords in Index table column names
Version 6.3.17 - December 12th, 2024
Fixes
- ZD-311652: Fixed parsing for the unicode replacement character and some other previously unsupported characters
Version 6.3.16 - December 3rd, 2024
Features
- Internal library updates
Version 6.3.15 - November 27th, 2024
Fixes
- Removed the option to compare Flyway toml projects
Version 6.3.14 - November 20th, 2024
Fixes
- ZD-299121: Fixed bug that caused User Object Privileges to be granted in deployment scripts before the object was created in some scenarios
Version 6.3.13 - November 13th, 2024
Features
- ZD-313837: Added a new comparison option to ignore the INCREMENT BY property of SEQUENCE objects.
- ZD-313837: Added a new comparison option to ignore the MINVALUE property of SEQUENCE objects.
- ZD-313837: Added a new comparison option to ignore the MAXVALUE property of SEQUENCE objects.
- ZD-319118: Resolved an issue with connecting to Oracle 19 and higher in Direct mode when using Oracle Encryption or Oracle Data Integrity
Version 6.3.12 - October 29th, 2024
Features
- Internal library updates
Version 6.3.11 - October 24th, 2024
Fixes
- ZD-307181: Fix missing column definitions for generated scripts when using INMEMORY tables
Version 6.3.10 - October 15th, 2024
Features
- Internal library updates
Version 6.3.9 - September 26th, 2024
Fixes
- ZD-309223: Prevent scripting of LOB clauses for extended RAW columns.
Version 6.3.8 - September 17th, 2024
Fixes
- ZD-312075: In comparisons, ignore case differences of conditional compilation flags for PL/SQL functions, triggers, packages and package bodies
Version 6.3.7 - September 12th, 2024
Features
- Internal library updates
Version 6.3.6 - August 27th, 2024
Fixes
- ZD-307606: Prevent scripting of LOB clauses within PARTITION statements for extended datatypes.
- ZD-316431: Fix for a perpetual difference on Local index storage due to PCTINCREASE.
Version 6.3.5 - July 25th, 2024
Features
- Internal library updates
Version 6.3.4 - June 11th, 2024
Fixes
- Additional fixes to ensure directory names in DEFAULT DIRECTORY statements are treated as identifiers there-by start quoting them accordingly when storing them in the script folders
- Changed the name of sco.tar.gz to include the version number
Version 6.3.3 - April 9th, 2024
Features
- Increased DEBUG logging detail for constraint population
Version 6.3.2 - March 19th, 2024
Fixes
- ZD-304493: Fixes the missing name quoting for directory names in an external table definition
Version 6.3.1 - February 27th, 2024
Compatibility with Data Compare for Oracle 6.3.1
Version 6.3.0 - January 16th, 2024
Features
- Added a new log level setting: Information
- Allows a flyway.toml Flyway configuration file to be opened in place of a Schema Compare for Oracle project file