2 Replies Latest reply on Oct 31, 2017 9:26 PM by Gary Graham-Oracle

    SQL Developer validation errors for new max length for objects in 12c

    Maxime Bélanger

      Hello all,

       

      We are using SQL Developer 4.2.0.17.089, working on an Oracle 12.2.0.1 database. As of Oracle 12c, the maximum name length for database objects has been raised to 128 bytes from the previous 30 bytes.

      It seems that this new max length has not been included in the SQL Developers UI Validations. We can for example do an "Alter table add VERY_LONG_COLUMN_NAME_OVER_30_CARACTERS_BUT_LESS_THAN_128_CARACTERS VARCHAR2(10)", but if we try to modify a table using the UI (Right click on table, choose "Modify"), we can't apply anything (even no changes) to the table, because we get a validation error :"Invalid name [...] The name [...] is too long."

       

      Is there any way to disable or correct these validations in SQL Developer options, or will this be fixed in a future version?

       

      Update: I have just tried with version 17.3.1.279, and the validation errors are still present.

       

      Thanks!

      Max

       

      Message was edited by: Maxime Bélanger Updated to latest SQL Developer version