Delete Statement and Storage
From: Geoffrey <g.dufour_at_swing.be>
Date: Thu, 20 Dec 2001 10:12:00 +0100
Message-ID: <3c21aa69$0$10325$ba620e4c_at_news.skynet.be>
Date: Thu, 20 Dec 2001 10:12:00 +0100
Message-ID: <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 - 10:12:00 CET