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.

"Ryan Gaffuri" <rgaffuri@cox.net> wrote in message
news:1efdad5b.0311061122.73fe6139@posting.google.c om...
> 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

On Fri, 7 Nov 2003 06:31:22 +1100, "Howard J. Rogers"
<hjr@dizwell.com> wrote:

>
>
>Alter database datafile X maxSIZE 4M;
>
>Also: alter database datafile X autoexend on;
>
>Regards
>HJR
>
Howard,

How restrained!

Jaap.