RE: identifier is too long

From: Bort, Guillermo <guillermo.bort_at_eds.com>
Date: Thu, 4 Dec 2008 14:00:32 -0600
Message-ID: <785A4E1EF4D9E745BAC909B7941BEC00B3767B@usplm201.amer.corp.eds.com>

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_at_eds.com <mailto:name.name_at_eds.com>  

We deliver on our commitments

so you can deliver on yours.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Thursday, December 04, 2008 5:52 PM To: TESTAJ3_at_nationwide.com
Cc: jose.soares_at_sferacarta.com; oracle-l_at_freelists.org; toon_at_rulegen.com 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_at_nationwide.com> 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_at_gmail.com>

To:

toon_at_rulegen.com

Cc:

jose.soares_at_sferacarta.com, oracle-l_at_freelists.org

Date:

12/04/2008 02:31 PM

Subject:

Re: identifier is too long

Sent by:

oracle-l-bounce_at_freelists.org  

---

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

---

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_at_dv10 SQL> desc dba_objects

Name                                                  Null?    Type
----------------------------------------------------- --------
------------------------------------

OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(128)
SUBOBJECT_NAME
VARCHAR2(30)

OBJECT_ID                                                      NUMBER



 

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

Received on Thu Dec 04 2008 - 14:00:32 CST