RE: identifier is too long
- From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- To: <jkstill@xxxxxxxxx>, <TESTAJ3@xxxxxxxxxxxxxx>
- Date: Thu, 4 Dec 2008 14:00:32 -0600
Jared, is that 128 bytes or 128 chars?
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
ITO
Arias 1851
Ciudad Autonoma de Buenos Aires (C1429DXC)
Argentina
Tel: +54 11 4704-3132
E-mail: guillermo.bort@xxxxxxx <mailto:name.name@xxxxxxx>
We deliver on our commitments
so you can deliver on yours.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Thursday, December 04, 2008 5:52 PM
To: TESTAJ3@xxxxxxxxxxxxxx
Cc: jose.soares@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; toon@xxxxxxxxxxx
Subject: Re: identifier is too long
I forgot about the lengthy db_link names.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On Thu, Dec 4, 2008 at 11:34 AM, <TESTAJ3@xxxxxxxxxxxxxx> wrote:
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 <http://dv10.radisys.com/>
STARTUP
--------------------
10/01/2008 09:42:19
11:26:22 ordevdb01.radisys.com <http://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:
