Re: Oracle block size limits
From: Vipin Gokhale <vgokhale_at_oraosf2.us.oracle.com>
Date: 1996/06/13
Message-ID: <spkyblrqjoz.fsf_at_oraosf2.us.oracle.com>#1/1
Date: 1996/06/13
Message-ID: <spkyblrqjoz.fsf_at_oraosf2.us.oracle.com>#1/1
Ayokunle Giwa <akgiwa_at_cnct.com> writes:
>
> Hi, is there an absolute limit on the number of blocks that a single
> database can have and what is it? ...if any.
>
Limit in Oracle 7.3 is 4M-1 blocks per data file. Typically one can have 1022 data files for the whole database. Number of data files is platform dependent.
--
=====================================================================
Vipin Gokhale
DEC SBU
Oracle Corporation
Disclaimer: Any opinions expressed here are mine and not that
of my employer.
=====================================================================
Received on Thu Jun 13 1996 - 00:00:00 CEST