Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: table/constraint max name length

Re: table/constraint max name length

From: Tanel Poder <tanel_at_@peldik.com>
Date: Thu, 6 Mar 2003 23:45:58 +0200
Message-ID: <3e67c0e5$1_2@news.estpak.ee>


Hi,

30 bytes, so if you have multibyte charset and nonstandard chars, the max could be even less than 30 characters (one char might take several bytes).

Tanel.

"Robert Diggle" <rob_at_nospam.org> wrote in message news:A1P9a.3$ND3.2947_at_newsfep2-gui...
> 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
>
>
Received on Thu Mar 06 2003 - 15:45:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US