RE: Maximum Number of columns in a table

Hi Kent

It's oracle8 limitation. AFAIK there are no any options to increase it.

Ed

>
>
> Dear List,
>
> A developer in our group tried creating a table with 1500
> columns. He got an
> error ORA-01792 stating that the maximum number of columns
> in a table or
> view is 1000.
>
> Is this a real limit imposed by Oracle or one that imposed by a
> mis-configuration?
>
> We are running Oracle 8.0.6 on Solaris 7.
>
> Thanks for your answers in advance.
>
> regards,
>
> Kent Szeto
> Email: mailto:Kent.Szeto_at_team.telstra.com
> <mailto:Kent.Szeto_at_team.telstra.com>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Szeto, Kent
> INET: Kent.Szeto_at_team.telstra.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 27 2000 - 00:12:45 CDT