4 Replies Latest reply: Mar 14, 2014 5:23 PM by rp0428 RSS

    DataModeler 4 - Unique Index (ERROR: Index name length exceeds maximum allowed length(30))

    c0bed161-4232-4f43-b87c-43608733e0f4

      Hi,

       

      When modeling a table with 3 columns as PK, engineering from Logical Model to Oracle 10g Relational Model, then visualizing the DDL script there is a CREATE UNIQUE INDEX section being created automatically. I could not find anywhere to replace the Unique Index name, since I get the following ERROR message:

       

      --  ERROR: Index name length exceeds maximum allowed length(30)

       

      Is there a way to fix this problem?

       

      Thanks in advance,

       

      Regards

       

       

       

      CREATE TABLE L011GPLA

        (

          CODGPR NUMBER NOT NULL ,

          CODANR NUMBER (4) NOT NULL ,

          CODPAN NUMBER (4) NOT NULL ,

          DCRANL TIMESTAMP (2) ,

          UCRANL VARCHAR2 (50) ,

          DALANL TIMESTAMP (2) ,

          UALANL VARCHAR2 (50)

        ) ;

      --  ERROR: Index name length exceeds maximum allowed length(30)

      CREATE UNIQUE INDEX L011GPLA_CODGPR_CODANR_CODPAN_IDX ON L011GPLA

        (

          CODGPR ASC , CODANR ASC , CODPAN ASC

        )

        ;