>>
>>Its an interesting guess, but seems to be wrong. Before I get into that
>>though - no-one seems to have answered Howard's question about the
>>number of files you can have in a bigfile tablespace. the number of
>>files you can have in such a tablespace is exactly one.
>
>
> So: I can have an 8 Exabyte tablespace, comprised of one single 8 Exabyte
> data file. Right?
>
At 32k data blocks, a bigfile tablespace can contain a single 128
Terabyte datafile. Times 64,000 and you have your 8 exabytes. Note that
smaller block sizes result in smaller databases.
Received on Thu Sep 16 2004 - 09:22:57 CDT
