Re: Maxbytes sifgnification
Date: Wed, 23 Jan 2008 06:12:35 -0800 (PST)
On 23 jan, 15:01, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> Comments embedded.
> On Jan 23, 7:25 am, teddyber <teddy..._at_gmail.com> 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.
not exactly. Actually I fell upon this question because I had (and
still have!) different values for BYTES and MAXBYTES columns for
datafiles not autoextensible.
BYTES is the size of the file on the filesystem.
> > Also, how is this
> > value initialized/changed by Oracle for this kind of datafile?
> alter database datafile '.......' resize [some number here];
this only affects the filesize and the changes the BYTES column on my server...
> 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:12:35 CST