Added support for comparing and deploying changes to Oracle native JSON columns.
修正
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.692026年7月31日
機能
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.
修正
Text objects with lines longer than 2499 characters can now be deployed correctly.
Schema Compare for Oracle 6.3.682026年7月23日
機能
Added initial support for the Oracle native JSON data type.
Added support for comparing and deploying Oracle Scheduler Job Arguments.
修正
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.672026年7月1日
機能
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.
修正
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.662026年6月3日
機能
Added support for comparing and deploying parameter changes to Oracle VECTOR columns. Deployment uses a table rebuild, which drops the vector column data.
修正
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.652026年5月21日
機能
Existence checks on adding and dropping table columns are now supported in preview.
修正
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.642026年5月12日
機能
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.
修正
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.632026年4月28日
修正
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.622026年4月21日
修正
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.602026年4月9日
機能
Improved error message when encountering unsupported built-in data types.
修正
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.582026年3月24日
修正
Fixed an issue where NOT NULL check constraints were still being scripted for Oracle GoldenGate columns.
Schema Compare for Oracle 6.3.572026年3月17日
機能
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.
修正
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.542026年2月19日
機能
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.532026年2月11日
機能
Added a comparison option to ignore invisible columns.
Added a command line switch to ignore invisible columns.
Comparison support for vector data types.
修正
Fixed a crash when selecting an empty snapshot in the Edit Project Dialog.
Schema Compare for Oracle 6.3.522026年2月3日
修正
Ignore columns with names that start with "CDRTS$". Relevant to Oracle Golden Gate generated columns.
Schema Compare for Oracle 6.3.512026年1月20日
機能
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.
修正
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.