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: 30 Character Limit on Oracle

Re: 30 Character Limit on Oracle

From: Noons <nsouto_at_optusnet.com.au.nospam>
Date: 18 Feb 2003 09:26:17 GMT
Message-ID: <Xns9326CD6A9E2F4Tokenthis@210.49.20.254>


Following up on Avi Abrami, 18 Feb 2003:

>
> When I was working with the Informix database -- several
> years ago -- they imposed an 18 charatcer limit on object
> names. After that, 30 characters seems like a _real_ lot!

Well, if you use UDB/DB2 in z/os, you get one length for usernames, another for table names. Then when you move your database to Unix or Windows or AS400, you gotta change the lot again as all the max lengths change too. Some "single code base", eh?

:D

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam
Received on Tue Feb 18 2003 - 03:26:17 CST

Original text of this message

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