Schema Compare for Oracle Versioni

Redgate SoftwareStrumenti di confronto dei database
Versione 6.3.x (15 set 2026)

Scopri le novità in ogni release, con dettagli su funzionalità, miglioramenti e problemi risolti.

gen
feb
mar
apr
mag
giu
lug
ago
set
ott
nov
dic
Schema Compare for Oracle 6.3.7515 set 2026
Funzionalità
  • Internal library updates.
Schema Compare for Oracle 6.3.7325 ago 2026
Funzionalità
  • Added "o"/"objectexistencechecks"/"object-existence-checks" value for the CLI behavior switch to expose this new (in preview) option.
Correzioni
  • Fixed comparisons involving a snapshot incorrectly showing a primary or unique key's backing index as a standalone object, or as inline, when the snapshot was captured with a different "Ignore index-related primary key construction differences" setting than the one active for the comparison.
Schema Compare for Oracle 6.3.7218 ago 2026
Funzionalità
  • Added support for comparing and deploying changes to Oracle native JSON columns.
Correzioni
  • 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.6931 lug 2026
Funzionalità
  • 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.
Correzioni
  • Text objects with lines longer than 2499 characters can now be deployed correctly.
Schema Compare for Oracle 6.3.6823 lug 2026
Funzionalità
  • Added initial support for the Oracle native JSON data type.
  • Added support for comparing and deploying Oracle Scheduler Job Arguments.
Correzioni
  • 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.671 lug 2026
Funzionalità
  • 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.
Correzioni
  • 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.663 giu 2026
Funzionalità
  • Added support for comparing and deploying parameter changes to Oracle VECTOR columns. Deployment uses a table rebuild, which drops the vector column data.
Correzioni
  • 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.6521 mag 2026
Funzionalità
  • Existence checks on adding and dropping table columns are now supported in preview.
Correzioni
  • 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.6412 mag 2026
Funzionalità
  • 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.
Correzioni
  • 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.6328 apr 2026
Correzioni
  • 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.6221 apr 2026
Correzioni
  • 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.609 apr 2026
Funzionalità
  • Improved error message when encountering unsupported built-in data types.
Correzioni
  • 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.5824 mar 2026
Correzioni
  • Fixed an issue where NOT NULL check constraints were still being scripted for Oracle GoldenGate columns.
Schema Compare for Oracle 6.3.5717 mar 2026
Funzionalità
  • 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.
Correzioni
  • 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.5419 feb 2026
Funzionalità
  • 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.5311 feb 2026
Funzionalità
  • Added a comparison option to ignore invisible columns.
  • Added a command line switch to ignore invisible columns.
  • Comparison support for vector data types.
Correzioni
  • Fixed a crash when selecting an empty snapshot in the Edit Project Dialog.
Schema Compare for Oracle 6.3.523 feb 2026
Correzioni
  • Ignore columns with names that start with "CDRTS$". Relevant to Oracle Golden Gate generated columns.
Schema Compare for Oracle 6.3.5120 gen 2026
Funzionalità
  • 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.
Correzioni
  • 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.