Schema Compare for Oracle Releases

Released: Jun 3, 2026

Updates in 6.3.66

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.

Released: May 21, 2026

Updates in 6.3.65

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.

Released: May 12, 2026

Updates in 6.3.64

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...

Released: Apr 28, 2026

Updates in 6.3.63

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.

Released: Apr 21, 2026

Updates in 6.3.62

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.

Released: Apr 9, 2026

Updates in 6.3.60

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.

Released: Mar 24, 2026

Updates in 6.3.58

Fixes

  • Fixed an issue where NOT NULL check constraints were still being scripted for Oracle GoldenGate columns.

Released: Mar 17, 2026

Updates in 6.3.57

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...

Released: Feb 19, 2026

Updates in 6.3.54

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.

Released: Feb 11, 2026

Updates in 6.3.53

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.