Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LMT not listed in DBA_FREE_SPACE
"charlie cs" <cs3526(no-spam)@yahoo.com> wrote in message
news:zQu4a.24438$Yv2.9754_at_nwrddc02.gnilink.net...
> For locally managed tablespace, how could we know how much is used, and
how
> much is still free for a Locally managed tablespace?
>
> Thanks
>
>
>
By using dba_free_space
Please note: if the size of the datafile minus 64k is not an *EXACT*
multiple of the extent size, you will 'loose' information. I once ran into
that when there was only 1 extent left which didn't 'fit'
Hth
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Tue Feb 18 2003 - 12:40:12 CST