Re: Max Extents Script

From: Kenneth C Stahl <BlueSax_at_Unforgetable.com>
Date: Tue, 25 Jan 2000 10:20:39 -0500
Message-ID: <388DBF47.B0065DF3@Unforgetable.com>

Lee Broders wrote:
>
> Does anyone have a script that will be able to give me when extents are
> reaching max_extents
> Please

select rpad(dt.table_name,30)||': '||

       lpad(to_char(ds.extents),3)||'/'||
       dt.max_extents
from sys.dba_segments ds,
     sys.dba_tables dt
where dt.owner = ds.owner

  and dt.table_name = ds.segment_name
  and ds.segment_type = 'TABLE'
order by dt.table_name; Received on Tue Jan 25 2000 - 09:20:39 CST