Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Max number of fields in Oracle
In Oracle 7 the limit is 255.
In Oracle 8 the limit is 1000.
Kenny Gump
Christopher Herold wrote in message <37694E0D.1CE1D5F_at_worldnet.att.net>...
>Can any one refresh my memory and tell me what the maximum number of
>fields that Oracle will allow in a table. I am on Oracle server version
>7.3.4. I have a flat file, which has 233 fields and I am looking into
>loading in to a test database as one table. I would prefer not to have
>to break up the flat file at this time into smaller tables.
>
>Thanks,
>Chris
>
>
Received on Fri Jun 18 1999 - 06:42:26 CDT