Re: 30 Character Limit on Oracle

Noons wrote:
>
> 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!

In our shop we limit table names to 25 char so we can append _PK, _IDX1, etc to them and still stay within 30 char.

>
> 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?

-- 
Andrew Allen