Re: identifier is too long
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: toon@xxxxxxxxxxx
- Date: Thu, 4 Dec 2008 11:28:39 -0800
On Thu, Dec 4, 2008 at 5:35 AM, Toon Koppelaars <toon@xxxxxxxxxxx> 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
------------------------------
DV10.RADISYS.COM
STARTUP
--------------------
10/01/2008 09:42:19
11:26:22 ordevdb01.radisys.com - js001292@dv10 SQL> desc dba_objects
Name Null? Type
----------------------------------------------------- --------
------------------------------------
OWNER VARCHAR2(30)
OBJECT_NAME
VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
Other related posts:
