Schema Comparison Does not Work When connected to 12c Cloud Control using SYSMAN (Doc ID 1936254.1)

Last updated on OCTOBER 16, 2014

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

+ EM 12c Cloud Control v.12.1.0.3.
+ EM is on top of Oracle Database 11.2.0.3.3.
+ The monitored target DB is on IBM's AIX 5.3 and is using Oracle 10.2.0.4.
+ Two tables are created for testing the "Schema Comparison" feature, one with one column, while the other is created with several columns.
+ "Schema Comparison" does not report the differences as expected.
+ One more test is held for two identical tables but with different column order. Although the "Ignore Table Column Positions" option is ticked, "Schema Comparison" does not report any differences.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms