Return
-
Title
COMMIT SCN attribute is not included when scrip is generated for MATERIALIZED VIEW LOG. -
Description
The Schema Browser | Create New option doesn't include the COMMIT SCN attribute for materialized view logs. Existing MV Log scripts also don't display the attribute (i.e. in Script tab, or when generating the DDL). Schema comparison & sync scripts also overlook this attribute. This causes problems when using Toad to compare. -
Resolution
WORKAROUND:
None
Note:
WITH COMMIT SCN is allowed only when creating a materialized view log. You can't alter a MV Log to add or remove this property. The changes planned in Toad will include fixes in regards to script display and create options. Schema Compare will note the difference but not attempt to make a change with sync scripts.
-
Defect ID
TOR-511 -
Additional Information
This issue has been resolved in version 12.9 of Toad for Oracle.