Schema Compare for Oracle 6.3 release notes
Published 16 January 2024
Version 6.3.45 - September 29th, 2025
Features
- Alters the effect of the Ignore system partitions option so that for Hash partitioned tables the quantity of any system named partitions will be taken into account in comparisons, but the names and other details of those system named partitions will be ignored.
Fixes
- ZD-336765: Added parser support for TYPE(LAX) and TYPE(STRICT) in JSON_QUERY and JSON_VALUE
- Raise Drop Partition warnings in deployment scripts that rebuild a partitioned table into a standard table.
Version 6.3.44 - September 17th, 2025
Features
- Upgrade .NET Framework version to 4.8
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