Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LMT not listed in DBA_FREE_SPACE
NoResult <dj_noresult_at_hotmail.com> wrote in
news:Xns9326CCDCF4643djnoresult_at_194.109.133.20:
> Please note that this does not include auto extend. If a datafile is
> set you should look in dba_data_files for the maximum size of the data
> file. Also exents should fit entirely free blocks. In locally managed
> tablespaces the next extent of a segment (table, index, etc.) can grow
> up to 64 M.
>
> Greetz, Arjan.
> Assistant Oracle DBA
>
>
sorry... corrections....
Please note that this does not include auto extend. If a datafile is set
to auto extend you should look in dba_data_files for the maximum size of
the data file.
Also exents should fit entirely in free blocks. In locally managed
tablespaces the next extent of a segment (table, index, etc.) can grow up
to 64 M.
Greetz, Arjan.
Assistant Oracle DBA
Received on Tue Feb 18 2003 - 13:11:49 CST