Paulgg
5th September 2002, 18:28
If lot of records have been deleted from a table, is it mandatory to perform reorganise tables to release the free spots in the table.

Does it mean that the table space is not reduced when a record is deleted.

We use baan4c4 on oracle.

Thanks

OmeLuuk
5th September 2002, 18:34
That is correct, deleting a record in the table just flips the "deleted" switch. In the database the record is still sitting there, occupying space. Until the table is reorganized.