Re: Largest Table Size in Oracle

In other words, 35,115,652,612,096 bytes, assuming an 8k os block size.

2^22 = 4194304
x 8192
x 1022
= 35,115,652,612,096 bytes

"Buck Turgidson" <jc_va_at_spamisnotcool.hotmail.com> wrote in message news:v13G6.19951$qc2.6264081_at_typhoon.southeast.rr.com...
> I was asked a question today which I couldn't answer. "What is the largest table
> that Oracle will support?"
>
> Looking in the 8i reference under "Physical Database Limits", it seems the
 question
> should be what is the largest file size, which is "Operating system dependent.
> Limited by maximum operating system file size; typically 2^22 or 4M blocks."
>
>
> Would I be correct by saying that a table will fit into a tablespace containing a
> file, whose size is OS dependent, but typically 2^22 x OS blocksize x 1022 (max
> files per tablespace - typically)?
>
>
>
>
Received on Thu Apr 26 2001 - 19:35:28 CDT