Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 30 Character Limit on Oracle
watch out for that one table that requires 11 indexes (or ten if you don't
know how to count).
-- Niall Litchfield Oracle DBA Audit Commission UK "Andrew Allen" <ajallen_at_mailhost.det.ameritech.net> wrote in message news:3E522756.F5926FCC_at_mailhost.det.ameritech.net...Received on Tue Feb 18 2003 - 07:50:07 CST
> 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