Script to find segment that have just ONE more extent

   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/