OEMM Unable to Harvest DB synonyms in DB schema

(Doc ID 2378320.1)

Last updated on MARCH 30, 2018

Applies to:

Oracle Enterprise Metadata Management - Version 12.2.1.2 and later
Information in this document applies to any platform.

Symptoms

Unable to Harvest database synonyms thru "Oracle Database (via JDBC)" bridge.

- Consider having two schemas in the Database.

- Schema1 contains tables and the schema2 contains synonyms about the schema1 tables.

- Now, when harvesting only the schema1, a warning is logged in the import log (as showed in the screen shot below) and the synonyms are not imported. 

Changes

 

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