My Oracle Support Banner

Unable To Select Multiple Database Schemas On OEMM Oracle Database (Via JDBC) Bridge (Doc ID 2195668.1)

Last updated on DECEMBER 18, 2019

Applies to:

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


There are two issues related to schema selection being observed in the OEMM

First: When creating a Oracle Database Model, when clicking in the magnifier in the Schema properties, this brings the list of schemas to be harvested. When selecting multiple schemas, the "Select" button did not became available.

Second: When entering one schema manually, and then clicking in the magnifier, it's possible to select multiple schemas and the "Select" button becomes available, but, the additional schemas do not get transferred to the bridge.

Steps to reproduce:

1.) Create a Oracle Database (via JDBC) model.

2.) In the "Schemas" parameter, click in the magnifier. The list of the schemas will show. Select one or more schemas.

3.) It's not possible to click in the "Select" button.


1.) Create a Oracle Database (via JDBC) model.

2.) In the "Schemas" parameter manually enter on schema.

3.) Then click in the magnifier. The schema will be auto-selected.

4.) Select additional schemas.

3.) Click "Select" button. The additional schemas did not get moved to the bridge "Schema" parameter.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.