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.