Re: table/constraint max name length

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 06 Mar 2003 14:22:00 -0800
Message-ID: <3E67CA08.46965589@exesolutions.com>

Robert Diggle wrote:

> Hi,
>
> I'm doing an assignment for uni, building a database in 9i.
>
> I've designed my tables and stuff, but they names are really long. Is there
> a max length or rule of thumb for table name length.
>
> Regards,
> Robert

Tanel is correct. In the future you can do the following to determine maximum sizes

DESC all_tables
DESC all_views
DESC all_source
DESC all_users

DESC user_tablespaces
etc.

Daniel Morgan Received on Thu Mar 06 2003 - 16:22:00 CST