Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: free space in an extent below High Watermark
frankzaum_at_yahoo.de (Frank Zaum) wrote in message news:<4c1e5bbe.0205160607.64c3145c_at_posting.google.com>...
> Hello,
>
> @ Oracle 8.1.7:
> i create a table XXX and add 10000 rows to it, then delete all of the
> rows from that table. After that i use SQL*Loader to insert another
> 10000 rows into
> that table. I guess the HWM block should now be twice as 'high' as
> after the delete, though still only 10000 rows populate the table.
>
> Question: can i find out how many space BELOW the HWM is free?
>
> TIA
>
> Frank Zaum, Salzgitter.
I THINK IF YOU DELETE ROWS FROM TABLE.ALL BLOCKS BECOME AVAILABLE IN FREELIST SO THEY WILL BE REUSED IN TABLE. HIGH WATER MAKE WON'T BE DOUBBLE Received on Fri May 17 2002 - 08:22:14 CDT