Re: Maxbytes sifgnification

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.

> 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