The Oracle (tm) Users' Co-Operative FAQ

What is the largest number of columns allowed in a table?


Author's name: Allan W. Tham

Author's Email: allanwtham@hotmail.com

Date written: Nov 28 2001

Oracle version(s): 8.1.7.0.0

What is the largest number of columns allowed in a table?

Back to index of questions


The maximum columns allowed for Oracle 7 is 255. An increase from 255 to 1000 columns was introduced in Oracle release 8.0


 

Further reading:Data Management and Storage Internals P.3-2


Back to top

Back to index of questions