Re: identifier is too long

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: "Howard Latham" <howard.latham@xxxxxxxxx>
  • Date: Thu, 4 Dec 2008 11:56:12 -0800

On Thu, Dec 4, 2008 at 11:51 AM, Jared Still <jkstill@xxxxxxxxx> wrote:

> Yes, I have seem many longer than 30 characters, just didn't look for them
> in a 10g database.
>
>
Now I'm not so sure.

PRODUCT                        VERSION              STATUS
------------------------------ -------------------- --------------------
Oracle Database 11g Enterprise 11.1.0.7.0           64bit Production
 Edition

  1* select max(length(object_name)) from dba_objects
11:54:46 ordb03.radisys.com - sys@pr02 SQL> /

MAX(LENGTH(OBJECT_NAME))
------------------------
                      30

1 row selected.

Other related posts: