Re: Maxbytes sifgnification
Date: Wed, 23 Jan 2008 06:01:51 -0800 (PST)
On Jan 23, 7:25 am, teddyber <teddy..._at_gmail.com> wrote:
> 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?
David Fitzjarrell Received on Wed Jan 23 2008 - 08:01:51 CST