Schema Compare issue with System Generated Named objects
説明
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));
対策
WORKAROUND
None
STATUS
Issue fixed in version 12.1.0 or higher. The latest version of Toad for Oracle can be downloaded here.