Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table field limit w/Oracle databases?
I know nothing of the product you refer to by 30 column tables and ODBC is
nothing strange or unusual
I have no idea what the problem could be that is being suggested
Personally I think you should be fine - unless the column size are themselves unusually large.
Regards
--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
<KevinALewis_at_HotMail.com>
The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
Chris Forlano <cforlano_at_nortelnetworks.com> wrote in message
news:375F7F53.9B18C798_at_nortelnetworks.com...
> We are using a product by Mercury Interactive (Test Director) that can
talk
> to an Oracle8 database service using ODBC.
>
> Some of their tables, to allow for easy user customization, have around 30
> columns.
>
> What kinds of trouble are we getting into.
>
> Thanks in advance,
>
> Chris
>
> Randy DeWoolfson wrote:
>
> > if you have more than 10 columns in a table.. then evaluate the schema.
> >
> > randy
> >
> > cary_at_nams.net wrote:
> >
> > > Hello,
> > >
> > > A couple of quick questions.... Is there a limit to the NUMBER
of
> > > fields in an Oracle database table? If so, does the limit depend on
> > > the database version 6, 7, 8, 8i, etc.? I remember running across
some
> > > document which quoted a limit of 255 fields, but I do not remember the
> > > specifics and could be entirely wrong. Thanks in advance.
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Share what you know. Learn what you don't.
>
>
>
> --
> Chris Forlano
> TMS Project Manager
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
>
>
Received on Thu Jun 10 1999 - 05:18:32 CDT