Re: free space in table

 information pertaining to _allocated_ bytes is in dba_segments. (select segment_name, owner, bytes, extents, max_extents   from dba_segments)

for _used bytes_ analyze table ... compute statistics, and consult the empty_blocks column of dba_tables.

Hth,

Sybrand Bakker, Oracle DBA

john flanagan <pti_at_iol.ie> schreef in berichtnieuws 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 Fri May 05 2000 - 00:00:00 CDT