Re: Delete Statement and Storage
Date: Thu, 20 Dec 2001 13:51:52 GMT
Message-ID: <Y1mU7.14181$xl6.1168835_at_rwcrnsc54>
It will use the freed space as long as the datablocks have been put on the
free list. Which means that the space that was freed in a block has to be
large enough so that the used space goes below the pctfree setting. For
example if you deleted all the data in the last 100 blocks in a segment then
yes. But if you deleted 1 row from each of 10,000 blocks and each row was
very small and not large enough to force the percentage of the space in any
block below the pctfree then no.
Jim
"Geoffrey" <g.dufour_at_swing.be> wrote in message
news:3c21aa69$0$10325$ba620e4c_at_news.skynet.be...
> Hi,
>
> I know that when you use the Delete statement to delete a large quantity
of
> rows it does not release space.
>
> Then, about the new rows inserted :
>
> Does Oracle use this "freed by a delete" space or does it allocate new
space
> for the new inserted rows.
>
> Btw, I'm running Oracle 8.0.5
>
> Regards.
>
>
Received on Thu Dec 20 2001 - 14:51:52 CET