pls note the change . number of columns is 1000 columns in a table in 8i version

Oracle7 Server Reference Book, Chapter 5, Database Limits
=======================================

object Limit
----------------------------------------------------
index(or cluster index) 16 columns maximum
table 254 columns maximum


Oracle8 Server Reference Book, Chapter 5, Database Limits
========================================

object limit
----------------------------------------------------------
table 1000 columns maximum
indexed 32 columns maximum
(or clustered index)
bitmapped index 30 columns