Re: identifier is too long

From: Jared Still <>
Date: Thu, 4 Dec 2008 11:28:39 -0800
Message-ID: <>

On Thu, Dec 4, 2008 at 5:35 AM, Toon Koppelaars <> wrote:

> No not possible.
> And two days ago at UKOUG Steve Feuerstein told us that Oracle had told him
> that this limit will never be changed.

Never is a very long time.

It also seems to be at odds with the size of the name column in dba_objects. Though the max length of any name in the db is 30 character, the potential for more appears in the DD.

PRODUCT                        VERSION              STATUS
------------------------------ -------------------- --------------------
NLSRTL                           Production
Oracle9i Enterprise Edition            Production
PL/SQL                           Production
TNS for Linux:                   Production

Data Base


10/01/2008 09:42:19

11:26:22 - js001292_at_dv10 SQL> desc dba_objects

 Name                                                  Null?    Type
 ----------------------------------------------------- --------
 OWNER                                                          VARCHAR2(30)
 SUBOBJECT_NAME                                                 VARCHAR2(30)
 OBJECT_ID                                                      NUMBER

Received on Thu Dec 04 2008 - 13:28:39 CST

Original text of this message