OEMM - Harvesting from Database That Has Materialized Views May Fails With "MBCM_F0029 [MBI_JDBC4_F0232] There already exists a MATERIALIZED_VIEW with the name '<MATERIALIZED_VIEW_NAME>' in the parent DatabaseSchema '<DB_SCHEMA_NAME>'" (Doc ID 2223067.1)

Last updated on JANUARY 17, 2017

Applies to:

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

Symptoms

While harvesting from Oracle Enterprise Metadata Management (OEMM) 12.2.1.1 using the "Oracle Database (via JDBC)" bridge, the import may fail with the following error when importing a Materialized View:

 

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