Schema Compare for Oracle Releases

Redgate SoftwareDatabase Comparison Tools
Version 6.3.x (Aug 18, 2026)

Learn what's new across releases, with details of features, enhancements, and resolved issues.

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Schema Compare for Oracle 6.3.72Aug 18, 2026
Features
  • Added support for comparing and deploying changes to Oracle native JSON columns.
Fixes
  • Enabling the "Ignore index-related primary key construction differences" option no longer changes how a primary or unique key is represented when its backing index simply shares the constraint's name. Previously the option promoted that index to a standalone object, which reported an index that had no file in the scripts folder, showed a USING INDEX clause the scripts folder did not contain, and queued up a change for every affected table as soon as the option was turned on.
Schema Compare for Oracle 6.3.69Jul 31, 2026
Features
  • Introduced new IncludeOnlineIndexCreation option in the UI and CLI to add 'ONLINE' clause to index creation scripts.
  • Cross-schema object permissions are now recorded only against the object's owner instead of against both the owner and the grantee. This stops the same grant being duplicated across two schemas (a common cause of drift when each schema is in its own project) and prevents deployment scripts from generating grants that the connected user cannot execute. Where the owner schema is outside the comparison, a grant that an in-scope object genuinely depends on is still kept so that object can deploy - a REFERENCES grant backing a foreign key, or a grant on an out-of-scope table or type used by an in-scope view, package or column. Grants on objects no schema owns (directories, editions and users) are unaffected and remain recorded against the grantee.
Fixes
  • Text objects with lines longer than 2499 characters can now be deployed correctly.
Schema Compare for Oracle 6.3.68Jul 23, 2026
Features
  • Added initial support for the Oracle native JSON data type.
  • Added support for comparing and deploying Oracle Scheduler Job Arguments.
Fixes
  • Fixed a crash when scripting a table whose foreign key references a table that is not present in the schema model.
  • Fixed an issue with some schema names being handled inconsistently, causing spurious object differences when "Ignore schema names" was enabled and producing schema references with the wrong casing, thus showing up as differences.
Schema Compare for Oracle 6.3.67Jul 1, 2026
Features
  • Narrowing the length of a VARCHAR2, NVARCHAR2 or RAW column is now deployed with a targeted UPDATE and ALTER TABLE MODIFY instead of a full table rebuild, where the column has no dependents that would prevent an in-place modification.
Fixes
  • Fixed tables with a system-generated primary key index being incorrectly reported as different (with the index shown as existing only in the scripts folder) when comparing a scripts folder to a database with the "Ignore index-related primary key construction differences" option enabled.
  • Improved the error message shown when LOB population fails with 'ORA-65047' because the 'XML_TAB_COLS' data dictionary views are invalid (for example on Oracle 'lite' images where the XDB component is not fully installed).
Schema Compare for Oracle 6.3.66Jun 3, 2026
Features
  • Added support for comparing and deploying parameter changes to Oracle VECTOR columns. Deployment uses a table rebuild, which drops the vector column data.
Fixes
  • Fixed a regression where comparing two snapshots with cross-schema privilege changes produced duplicate permissions.
  • Fixed object existence checks producing invalid scripts when object names, owners, column names or column defaults contained single quotes.
Schema Compare for Oracle 6.3.65May 21, 2026
Features
  • Existence checks on adding and dropping table columns are now supported in preview.
Fixes
  • Fixed an issue where altering a materialized view log from INCLUDING NEW VALUES to EXCLUDING NEW VALUES produced a script that did not change the target.
Schema Compare for Oracle 6.3.64May 12, 2026
Features
  • Added snapshot support for the Oracle 23ai VECTOR data type.
  • Existence checks on creates and drops for the following objects are now supported in preview:
    • Functions.
    • Indexes.
    • Jobs.
    • Materialized views.
    • Materialized view logs.
    • Packages.
    • Procedures.
    • Queues.
    • Queue Tables.
    • Schedules.
    • Sequences.
    • Synonyms.
    • Tables.
    • Triggers.
    • Types.
    • Views.
Fixes
  • Fixed an issue where Time Zone information was not being respected for job objects.
  • Fixed issue where adding a column to an existing unique constraint backed by a separately-defined index produced duplicate DROP UNIQUE and ADD CONSTRAINT statements, causing ORA-02442 on deployment.
Schema Compare for Oracle 6.3.63Apr 28, 2026
Fixes
  • Fixed an issue where object tables defined with a type from a different schema were scripted with the wrong schema qualifier in the OF clause.
Schema Compare for Oracle 6.3.62Apr 21, 2026
Fixes
  • Fixed issue caused by extended UNICODE characters within string literals in script folders.
  • Fixed an object ordering issue in deployment scripts where "job to schedule" dependencies were not respected.
Schema Compare for Oracle 6.3.60Apr 9, 2026
Features
  • Improved error message when encountering unsupported built-in data types.
Fixes
  • Fixed issue where LOCAL indexes on reference-partitioned tables were scripted with an incomplete explicit partition list, causing ORA-14024 on deployment.
Schema Compare for Oracle 6.3.58Mar 24, 2026
Fixes
  • Fixed an issue where NOT NULL check constraints were still being scripted for Oracle GoldenGate columns.
Schema Compare for Oracle 6.3.57Mar 17, 2026
Features
  • Added a new option to script a condition around GRANTs and REVOKEs to ensure that these statements are skipped if the grantee/revokee is the user running the deployment script.
  • Added a preview comparison option to add existence checks to scripts - currently supports index creation statements.
Fixes
  • Fixed a problem with the identification of 'grant to self' issues in deployment scripts.
  • Fixed an issue where the constraint index of an invisible virtual column was not being scripted out correctly.
Schema Compare for Oracle 6.3.54Feb 19, 2026
Features
  • Added a command line switch to ignore invisible indexes.
  • Added a comparison option to ignore invisible indexes.
  • Added support for extended unicode characters within object names in script folders.
Schema Compare for Oracle 6.3.53Feb 11, 2026
Features
  • Added a comparison option to ignore invisible columns.
  • Added a command line switch to ignore invisible columns.
  • Comparison support for vector data types.
Fixes
  • Fixed a crash when selecting an empty snapshot in the Edit Project Dialog.
Schema Compare for Oracle 6.3.52Feb 3, 2026
Fixes
  • Ignore columns with names that start with "CDRTS$". Relevant to Oracle Golden Gate generated columns.
Schema Compare for Oracle 6.3.51Jan 20, 2026
Features
  • 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.
Fixes
  • 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 where Schema Compare was incorrectly reporting a difference for changes in case for comment statements and alter views in a script folder.