Re: Oracle7 database size limit (or tablespace size)?

The maximum size in Oracle7 is determined by

Maximum number of files : 1023 files
Maximum number of blocks per file : 4,000,000 (but many filesystem are limted to 2Gb files)
Maximum block size : 16k (on most platforms)

So in theory that gives you : 1023 * 4,000,000 * 16k = 65,472 Gb This figure is alot larger in Oracle8 where you can have 1022 tablespaces and 1023 files per tablespace (I think that gives 4Pb ? )

Regards
David Russell

John Cai wrote in message <01bdc333$3e3bd960$be1c52ca_at_default>...
>Can anyone tell the size limit of an Oracle database (7.1, 7.2, and 7.3)?
>Can it be in tera-byte order?
>
>I tried to look at Oracle web site, but found a big mess there: many pages
>are missing in Product Info, and the esarch engine shows lots of lost
>links. I could not allocate any data sheet for Oracle7.
>
>John Cai
>jcai01_at_hkstar.com
Received on Sun Aug 16 1998 - 15:56:07 CDT