Re: Maximum size of index and sequence name

From: gazzag <gareth_at_jamms.org>
Date: 23 May 2006 08:17:39 -0700
Message-ID: <1148397459.337144.280040@y43g2000cwc.googlegroups.com>

sybrandb_at_yahoo.com wrote:
> b) Identifiers are always 30 characters long
> Sybrand Bakker
> Senior Oracle DBA

Indeed. However:

SQL> desc dba_objects

Name                                      Null?    Type
----------------------------------------- -------- ----------------
OWNER                                              VARCHAR2(30)
OBJECT_NAME                                        VARCHAR2(128)
SUBOBJECT_NAME                                     VARCHAR2(30)
OBJECT_ID                                          NUMBER
DATA_OBJECT_ID                                     NUMBER
OBJECT_TYPE                                        VARCHAR2(18)
CREATED                                            DATE
LAST_DDL_TIME                                      DATE
TIMESTAMP                                          VARCHAR2(19)
STATUS                                             VARCHAR2(7)
TEMPORARY                                          VARCHAR2(1)
GENERATED                                          VARCHAR2(1)
SECONDARY                                          VARCHAR2(1)

The only object that can have a length greater than 30 characters is a database link, which can be up to 128.

HTH -g Received on Tue May 23 2006 - 10:17:39 CDT