Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple question on column limits
In article <3AC3E709.5A22446F_at_thanks.com>, Trevor <nospam_at_thanks.com>
writes:
>
>Can't find the answer in the Oracle 8i DBA Bible.
>
>What is the limit on the number of columns that can
>be defined in a table?
>
>--
>Cheers
>Trevor
>
>Reply to address invalid, when replying directly please use
> tcn at inform dot co dot nz
I went to look your answer up and could not find it, but I am pretty sure that Oracle 8 changed the number of columns allowed from 254 to 1000 and this did not change in 8.1.
![]() |
![]() |