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>
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