Reusing space after deleting rows in Oracle
<p>In Oracle the space allocated for data after <code>INSERT INTO</code> operation is not cleaned up when deleting rows from the table. Instead, after <code>DELETE FROM</code> operation some "waste space" is left. So what happens when I do <code>INSERT INTO</code> after <code>DELETE FROM</code> - does it span this "waste space" or allocates new space again?</p>