Re: identifier is too long

On Thu, Dec 4, 2008 at 5:35 AM, Toon Koppelaars <toon_at_rulegen.com> 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                         9.2.0.8.0            Production
Oracle9i Enterprise Edition    9.2.0.8.0            Production
PL/SQL                         9.2.0.8.0            Production
TNS for Linux:                 9.2.0.8.0            Production

Data Base

11:26:22 ordevdb01.radisys.com - js001292_at_dv10 SQL> desc dba_objects

 Name                                                  Null?    Type
 ----------------------------------------------------- --------
------------------------------------
 OWNER                                                          VARCHAR2(30)

 SUBOBJECT_NAME                                                 VARCHAR2(30)
 OBJECT_ID                                                      NUMBER

--
http://www.freelists.org/webpage/oracle-l