Designer Returns Duplicate Table Names with Oracle

Metastorm

The information in this article applies to product: e-Work 5.x 6.x

Issue

• For example, an Oracle database contains two schemas - one is owned by USER\_A and the other by USER\_B. Each schema contains a table named 'Customers'. Access to both schemas is granted to USER\_X. When the Designer is used to view the external Oracle database, and connects as USER\_X, the table 'Customers' will be listed twice.

Resolution

• The Designer was built to work with both MS SQL Server and Oracle using a DSN connection. Because it connects to a database and not to a schema, this is expected behavior. Make sure any common tables specify the table owner, e.g. USER\_B.Customers.