Re: Maxbytes sifgnification

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