Re: identifier is too long

From: <>
Date: Thu, 4 Dec 2008 14:34:11 -0500
Message-ID: <>

its that crazy database link thing :)


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.

"Jared Still" <>
Cc:, Date:
12/04/2008 02:31 PM
Re: identifier is too long
Sent by:

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

Data Base


10/01/2008 09:42:19

11:26:22 - js001292_at_dv10 SQL> desc dba_objects

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

 OBJECT_ID                                                      NUMBER

Received on Thu Dec 04 2008 - 13:34:11 CST

Original text of this message