Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> free space in an extent below High Watermark

free space in an extent below High Watermark

From: Frank Zaum <frankzaum_at_yahoo.de>
Date: 16 May 2002 07:07:22 -0700
Message-ID: <4c1e5bbe.0205160607.64c3145c@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. Received on Thu May 16 2002 - 09:07:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US