tablespace growth and freespace
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.
What do you think ALTER TABLESPACE "" COALESCE does?
Originally Posted by cabruntz
The freed space is available to the table in which the row was deleted. It will not be available to other table/index.
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?
You need to study how pctfree and pctused parameters work in Oracle blocks.
wow, i really find guys cute, who ask questions like this. looks so
innocent, its like i want to teach him some lessons (oracle dba at least)
Cab, what u really be concerned of is your FREESPACE if you
think it falls on the treshold then add more, anyways disks are
cheap now adays. At least its a control u got on this
application/database. But still, deleting unwanted rows works
fine for the table itself.
Last edited by yxez; 09-19-2006 at 08:26 PM.
Behind The Success And Failure Of A Man Is A Woman
you have a real nack of not answering the question asked at all
Originally Posted by yxez
Click Here to Expand Forum to Full Width