Generate database with DBMS "oracle version 19c" : allow table names longer than 40 characters

[former_member1342517]

Since oracle 12c, table names (also index names, constraint names, ...) are allowed to be more than 40 characters long.

In PowerDesner (16.7), I create the DDL-statements from my model.

I modified the model options Naming conventions --> Table --> Code --> Maximum lenght: 128 characters. So all codes can have 128 characters.

When doing "generate Database" with DBMS "Oracle Version 19c", all the identifiers (table names, index names, ..) are truncated to 40 characters.

Is there a way to create Oracle DDL-statements with table-names > 40 characters ?

[former_member763929]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[Ondrej_Divis · Accepted solution]

Hi Geert,

setting maximum allowed lengths is a little bit tricky in PowerDesigner. There are two places where you can affect it and PowerDesigner automatically applies the stricter setting to generated code. One place is Model Options - Naming Convention. To be precise, Naming conventions node and Naming Convention - Table node, which can override general settings from Naming Convention node.

The other place is in your definition file. Open menu Database - Edit current DBMS file and go to Script\Objects\Table\Maxlen. There you find your 30 characters restriction. If you enlarge it here, it will start working as you need. You have to adjust it separately for other objects too (Column, Index, etc.)

Regards,

Ondrej Divis

[former_member1342517 · Accepted solution]

Hi Ondrej,

Thank you very much for your help.You have served me well.
I have been searching for weeks in all the parameters, but couldn't find a solution.

regards,

Geert

[JamesZ]

<
When doing generate Database with DBMS "Oracle Version 19c", all the identifiers (table names, index names, ..) are truncated to 40 characters.

>

Why? Do you have any idea whether the "truncated to 40 characters" was done by application on top of this database, or database itself? It looks database itself won't do cut.....

[former_member1342517]

Hi James, thanks for you reaction.
I'm using PowerDesigner 16.7 to generate the DDL statements. I refined my question.

[former_member1342517]

Hi James, thanks for your reaction. I"m using PowerDesigner 16.7.

I've refined my question to make it more clear

[JamesZ]

thanks for the feedback, then it looks like power designer cut the characters....