Re: oracle tables...max columns

A copy of this was sent to NJDAVE65_at_aol.com (if that email address didn't require changing) On Wed, 11 Aug 1999 15:17:40 GMT, you wrote:

>Hi everyone:
>quick question, I'm looking to seee if there is a limit to the number of
>columns you can have in oracle8. I can't find any trace of a limit, does
>anyone know for sure? Dave
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Oracle8 server reference has a section "database limits"

there is a limit of 1000 columns/table in Oracle8.0 and up. It was 254 in 7.3 and before.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Aug 11 1999 - 10:39:12 CDT