Return
-
Title
ORA-12014: table 'string' does not contain a primary key constraint Error Generated When Comparin -
Description
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). -
Resolution
WORKAROUND:
None
STATUS:
Issue fixed in version 9.1. The latest version of Toad for Oracle can be downloaded here.