The simple "Can I extend" question

Just wondering what people are doing out there to answer the question
"Can segment X take a new extent?"...

Seems easy enough....for segments in a tablespace that is:

1. Dictionary-managed: xxx_SEGMENTS.NEXT_EXTENT versus DBA_FREE_SPACE
2. Converted LMT: ditto
3. Uniform LMT: trivial (simple existence check in DBA_FREE_SPACE)
4. System-alloc LMT: hmmmmmmmmmm

(xxx_SEGMENTS.NEXT_EXTENT is null in (4)

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk



"Some days you're the pigeon, some days you're the statue..."