My Oracle Support Banner

Why DMW Has UI Restriction Of 20 Characters On Data Model Schema Name? (Doc ID 2281609.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.6 and later
Information in this document applies to any platform.


Why DMW UI has a restriction on Data Model Schema Name? Data Model BA Schema name is restricted to 20 characters in UI.

 Is there any specific reason for it, given that Oracle allows schema name up to 30 bytes/chars?

The _DEV, _QC or _PROD is suffixed depending on the life cycle. But even then the total length comes to 20+5 (for _PROD) = 25 chars.

What is the reason behind this restriction on DMW UI Data Model Schema Name?

Steps to reproduce

1. Create a DMW Data Model
2. Check Business Area option - to create an associated BA for this Data model
3. Try to enter a BA schema name longer than 20 chars and it will not be permitted.


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.