Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table field limit w/Oracle databases?
cary_at_nams.net escribió:
> =
> 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.
The limit is 254 for Oracle 7.x and 1000 for Oracle 8.x =
Regards.
-- =
Julio Negueruela
DBA Servicio Informático
Universidad de La Rioja - Spain Telf: 941-299179 Fax: 941- 299180
![]() |
![]() |