Oracle limit is in 30 characters

Oracle limit entity name is in 30 characters. But when I generate ERD from ClassDiagram, entity name is generated as “#Class3ClassID”. If I generate N-level inheritance, entity name may be larger than 30 characters. What should I do in this case?
TIA, Eugeny

Hi Eugeny,

Thanks for your inquiry. When generate ERD from class diagram, the entity name will follow name of mapped class - it should not be “#Class3ClassID”. Would you mind to tell me whether you set any option or did anything to have this class name pattern?

By the way, I’m wondering if you actually mean column name instead of entity name.
If this is the case, you can configure the PK/FK pattern, PK constraint pattern and FK relationship pattern at Tools > Options > Diagramming > ERD & ORM (as image). After configuration, synchronize from ERD to class diagram again.
Alternatively, you can rename the columns manually to reduce length of column name.

Best regards,
Lilian Wong


Thanks! Yes, I am meaning column name.

Hi Eugeny,

You are welcome.

Bets regards,
Lilian Wong