| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ?: Maximum Number of columns in a table
The maximum column you can create in a table is 1000 in oracle 8.x
That is limit by orcale 8.x.
Bye.
-----OE=B3'=CCf=81fbfZ=81[fW-----
=8D=B7=8Fo=90l: Szeto, Kent [mailto:Kent.Szeto_at_team.telstra.com]
'-=90M"=FAZz: Friday, October 27, 2000 PM 02:15
^=B6=90=E6: Multiple recipients of list ORACLE-L
OE=8F-=BC: Maximum Number of columns in a table
Dear List,
=20
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.=20
=20
Is this a real limit imposed by Oracle or one that imposed by a
mis-configuration?
=20
We are running Oracle 8.0.6 on Solaris 7.
=20
Thanks for your answers in advance.
=20
regards,=20
Kent Szeto=20
Email: mailto:Kent.Szeto_at_team.telstra.com
<mailto:Kent.Szeto_at_team.telstra.com> =20
=20
=20
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
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 Thu Oct 26 2000 - 23:58:48 CDT
 |
 |