Re: Maxbytes sifgnification

From: <>
Date: Wed, 23 Jan 2008 06:01:51 -0800 (PST)
Message-ID: <>

Comments embedded.
On Jan 23, 7:25 am, teddyber <> wrote:
> Hello,
> I understand what this MAXBYTES column (DBA_DATA_FILES) means for an
> autoextensible datafile. What I don't know is the meaning of this
> column when the datafile is NOT autoextensible.

It's the current size of the datafile.

> Also, how is this
> value initialized/changed by Oracle for this kind of datafile?

alter database datafile '.......' resize [some number here];

which sets the maxbytes to the newly adjusted size.

> I can't find any clue in Oracle doc or groups or any Oracle related-
> page. Anyone can tell?
> Thanks.

David Fitzjarrell Received on Wed Jan 23 2008 - 08:01:51 CST

Original text of this message