The Compare Schema functionality creates DDL statements in the synchronization file in the wrong order under the following circumstances:
1. Reference Source Schema contains a table with a materialized view log.
2. In the Comparison Source Schema, neither table nor materialized view log exist.
When you compare the two schemas, this is the format of the synchronization file that is generated:
CREATE TABLE
CREATE MATERIALIZED VIEW LOG
ALTER TABLE ADD CONSTRAINT xyz PRIMARY KEY...
This order always causes the creation of the materialized view log to fail with an ORA-12014 (table 'string' does not contain a primary key constraint).
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center