I'm not sure to understand what you want.
Is it not this:
select segment_name from user_segments where extents=max_extents-1;
--
Have a nice day
Michel
"Luis Santos" <lsantos_at_pobox.com> a écrit dans le message news: 93cc8o$db5$1_at_nnrp1.deja.com...
> Hello!
>
> There are several scripts on the Web (and itīs easy to write one!)
> that show the segments that canīt be extended anymore, due to
> maxextents reached or no more contiguous space on the segmentīs
> tablespace.
>
> But itīs not easy to find or write a script that shows all the
> segments that can allocate more one, and only one, extent.
>
> Does someone has such a script?
>
> Best regards
>
> --
> Luis Santos
> Oracle DBA
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 08 2001 - 08:18:23 CST
