We have an 8i database. This is a third party setup so I don't have a lot of control. One of the schemas is a 37GB now. I cannot find a answer to this question. If I delete rows from one table in the schema, is the freed up space available for all tables in the schema or just the table where the rows are deleted?
I do run the ALTER TABLESPACE "" COALESCE after the deletes.

thanks