Re: is it possible to change maxblocks on the datafile?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 7 Nov 2003 06:31:22 +1100
Message-ID: <3faaa191$0$3788$afc38c87@news.optusnet.com.au>

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0311061122.73fe6139_at_posting.google.com...
> We have tablespaces each with 1 datafile. Some of them have max blocks
> at 4.1m and others at 2.2m. I believe the maxblocks and maxbytes
> settings only come into play with autoextend on since i can resize my
> datafile to larger than maxblocks.
>
> however, I want my datafiles to be able to extend. I cant dig up any
> syntax on how to alter maxblocks on OTN or metalink. is it possible?
> if nto how do you deal with this and how does oracle determine your
> default maxblocks?
>
> i tried
>
> alter database datafile/<datafile path>/<datafile> maxblocks 4m;
>
> Tried it with the autoextend command in there as well.

Alter database datafile X maxSIZE 4M;

Also: alter database datafile X autoexend on;

Regards
HJR Received on Thu Nov 06 2003 - 13:31:22 CST