Re: Max Extents Scripts

From: Eric Richardson <eric.richardson_at_mail.tju.edu>
Date: Tue, 25 Jan 2000 20:40:32 -0500
Message-ID: <86lisf$vnd$1@omle.tju.edu>

Here's a script to check on max extents. &offset would be how many extents it has before reaching its max.

select extents,segment_name from dba_segments

where (max_extents - &offset) <= extents;

Eric Richardson
Thomas Jefferson University

Lee Broders <lee_at_newapply.com> wrote in message news:388e2aa9.0_at_energise.enta.net...
> Does anyone have a script that will check if any of the table extents are
> nearing max_extent
> Please
>
>
Received on Tue Jan 25 2000 - 19:40:32 CST