Re: identifier is too long
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: jkstill@xxxxxxxxx
- Date: Thu, 4 Dec 2008 14:34:11 -0500
its that crazy database link thing :)
joe
_______________________________________
Joe Testa, Oracle Certified Professional
Senior Consultant
Data Engineering and Administration
Nationwide Investments
(Work) 614-677-1668
(Cell) 614-312-6715
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 12-14, 2008 here in Columbus.
From:
"Jared Still" <jkstill@xxxxxxxxx>
To:
toon@xxxxxxxxxxx
Cc:
jose.soares@xxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date:
12/04/2008 02:31 PM
Subject:
Re: identifier is too long
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
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:
