Re: Max number of fields in Oracle

From: William Richard Jones, CCP <wjones_at_acxiom.com>
Date: Thu, 17 Jun 1999 21:56:10 -0500
Message-ID: <3769B549.495404DB@acxiom.com>

Chris,

I belive the limit for Oracle 7 was 254 columns. I know from experience that the limit in Oracle 8 is 1000.

William Jones

Christopher Herold wrote:

> 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 Thu Jun 17 1999 - 21:56:10 CDT