Number of table and index extents

From: Paul Crozier <Paul_Crozier_at_mindlink.bc.ca>
Date: 22 Jan 94 06:32:12 GMT
Message-ID: <37024_at_mindlink.bc.ca>


Hello Oracle Guru's:


I was wondering if anyone has written a sql script that tells you how many table and index extents you have left in your database ( ie. maximum table or index extents minus table or index extents used).

Also, could you write this in a PLSQL script to put out a message depending on your running out of extents for a particular table or index.

You can reach me at: pcrozier_at_mindlink.bc.ca or mindlink!Paul_Crozier_at_rsoft.rsoft.bc.ca

Thanks a bunch, Paul Received on Sat Jan 22 1994 - 07:32:12 CET

Original text of this message