Re: Largest Table Size in Oracle

You're out by a couple of orders of magnitude here ;)

The maximum file count for a tablespace is 65533. Each file can be 4 M blocks (2^22)
Each block can be 32K

A table can be partitioned - so can be spread across all tablespaces you create, whether it is 66 tablespaces of ca. 1000 files each, or 65,000 tablespaces of 1file each.

Call the file count 65536 for convenience - So the maximum table size would be:

    2 ^ 16 (file count)
x 2 ^ 22 (block count)
x 2 ^ 15 (block size)

• 2 ^ 53, or about 8 Petabytes, rather than your 32 Terabytes.

Of course, we haven't left room for indexes, so the tablescans might take some time.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Buck Turgidson wrote in message ...


>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)?

>>

>>

>>

>>

>

>