Re: 30 character limit for table/column names?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 18 Feb 2007 10:45:51 -0800
Message-ID: <1171824350.545026@bubbleator.drizzle.com>

Timasmith wrote:
> In 10g is Oracle past the 30 character limit for table names and
> columns?
>
> thanks
>
> Tim

QL*Plus: Release 10.2.0.2.0 - Production on Sun Feb 18 10:44:44 2007

onnected to:
racle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production ith the Partitioning, OLAP and Data Mining options

QL> desc user_tables

Name                                      Null?    Type
----------------------------------------- -------- ------------------
TABLE_NAME                                NOT NULL VARCHAR2(30)
TABLESPACE_NAME                                    VARCHAR2(30)
CLUSTER_NAME                                       VARCHAR2(30)
IOT_NAME                                           VARCHAR2(30)
STATUS                                             VARCHAR2(8)
PCT_FREE                                           NUMBER

Remember the need for synchronization. If Oracle goes to 35 ... so does every tool that must connect to it. I suspect we won't see that any time soon.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Feb 18 2007 - 12:45:51 CST