Re: free space in table

I use the following scripts which gives me enough warning to make some changes before it too late, without having to wade through a huge list of tables.

select owner, bytes, extents, max_extents, segment_name from dba_segments
where extents >= trunc(max_extents * 0.9)

select extents, max_extents, initial_extent, next_extent, bytes, segment_name
from dba_segments s
where (next_extent * 1.5) >
(select max(bytes)
  from dba_free_space f
  where f.tablespace_name = s.tablespace_name)

Regards
Jason

john flanagan <pti_at_iol.ie> wrote in article <WgxQ4.7860$xA.19972_at_news.iol.ie>...
> Is there a function in PL/SQL to check the space available in a table.
 I
> can check data files and table spaces using the storage manager but I
 can't
> find a way to see if tables are reaching their max extents
>
>
>
Received on Sun May 07 2000 - 00:00:00 CDT