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

From: Peter Buzanits <peter_at_icb.co.at>
Date: Tue, 18 Aug 1998 13:28:29 +0200
Message-ID: <35D9655C.261EDC54@icb.co.at>

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

I think, Oracle8 has a maximum datafile-size of 32 GB. You can have 1022 datafiles per tablespace. This is about 32 TB per tablespace. I don't know if there is a limit on the number of tablespaces. If it is really 1022 as you write, you could put about 32 PB into you database...

Greeting,
Peter Buzanits
ETM Austria Received on Tue Aug 18 1998 - 06:28:29 CDT