Re: Question regarding deleting data.

On 7 May 2003 09:35:47 -0700, floyd5432_at_yahoo.com (Floyd) wrote:

>Hi,
>
> I've a problem with deleting data from an oracle 8i database.
>I've a java program that goes and deletes data from the database
>(typically about 20-50 rows spread accross 20 tables).
>
>Now the problem is when I delete the data, the space that is freed up
>does not show up as free space. Like after deleting 10000 rows for
>example, the amount of space in the tablespace and the amount of space
>in the index, before and after the delete is the same. Is this
>something to do with High Water Mark settings?
>
>How do I delete the data and make the space made available count
>towards the database free space.
>
>Thanks,
>
>Anwar.

You don't. Free space in a segment is automatically reused. This is Oracle, not some toy product.
Please read up on space management in the Oracle Concepts manual.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed May 07 2003 - 12:32:34 CDT