Schema Compare issue with System Generated Named objects (4334708)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Schema Compare issue with System Generated Named objects
Description

The schema compare option cannot cope with identical index/constraints that were named with a system generated SYS_C00 name as it reports a difference when there isn't one. A typical scenario where this occurs is a Primary Key on a table, for example, ALTER TABLE table_name ADD (PRIMARY KEY (Col1, Col2));
Resolution

WORKAROUND
None
STATUS
Issue fixed in version 12.1.0 or higher. The latest version of Toad for Oracle can be downloaded here.
Defect ID

110527

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title