Re: max extents
Date: Tue, 12 Apr 1994 21:01:39 +0200
Message-ID: <dischner-120494210139_at_u7x5201.ppp.lrz-muenchen.de>
In article <uoVkkc2w165w_at_vllyoak.resun.com>, jp_at_vllyoak.resun.com (Jeff Perry) wrote:
> hecker_at_panix.com (Jared P. Hecker) writes:
>
> > > Is there a way to increase the maxextents for a tablespace?
> > > Currently, the largest value I can enter for one is 249.
> > > I am using oracle 7 on aix 3.2.3.
> > >
> >
It depends on the blocksize of the database. In Unix it's normally 4096
There maxextents is your value.
I am running Oracle on IBM RS6000 with AIX 3.2.5 and a blocksize of
8192 (Oracle is 7.0.12, The setup instruction for block sizes other
than default 4096 is wrong).
My maxextents is now 505.
There is a script called dbfsize (i think) which gives the blocksize of a existing database file.
But remenber, you can only change the block size by recreating your complete database.
I hope this helps,
Toni Received on Tue Apr 12 1994 - 21:01:39 CEST