generate DDL - oracle sequence name length limit

[Bruce Thomason]

Background:
Oracle native sequence name lengths are 30 characters.
DDL generation from EA for autonum fields can result in a longer sequence name - the SEQ appears to use both the table name and field name.

Question: is there a means to control the sequence's name construction pattern name through DDL templates or otherwise and/or to have EA honor the Oracle name length limitation?

[rsharma]

Hi
I am experiencing the same issue stated above. Was a resolution/workaround discovered?
Thanks

[Arshad]

Hi rsharma


From Oracle 12.2 and above character limit is increased.
Please refer https://docs.oracle.com/database/121/SQLRF/sql_elements008.htm#SQLRF00223 for more details

Arshad

[Nizam]

Background:
Oracle native sequence name lengths are 30 characters.
DDL generation from EA for autonum fields can result in a longer sequence name - the SEQ appears to use both the table name and field name.

Question: is there a means to control the sequence's name construction pattern name through DDL templates or otherwise and/or to have EA honor the Oracle name length limitation?

You can try to if configuring Name Template from 'Settings | Project Options | Source Code Engineering > DDL: DDL Name Templates'  would help

or go to DDL Template Editor -> Oracle, and edit the $SeqName variable construction. It uses a template call $DDLName% which takes into account parameters like "Include_Owner", "Include_Surround". Trial with these to adjust Name