Re: Determining when the NEXT EXTENT will happen

use the old method, the ROWID, and determine how many oracle block had that table been used.

select count(*) from
(select distinct substr(rowid,1,8) from table1);

But I can't find of a way to find out the index though..

Winnie

Rob wrote in message ...
>Is there someone who can tell me how to determine when an object (table or
>index) is going to throw an additional extent. ie.) how to find the
>highwatermark of the current extent, or something like that?
>
>Thanks,
>Rob.
>
>
Received on Wed Oct 28 1998 - 00:00:00 CST