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.
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
What do you think ALTER TABLESPACE "" COALESCE does?
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?
The freed space is available to the table in which the row was deleted. It will not be available to other table/index.
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 07:26 PM.
Behind The Success And Failure Of A Man Is A Woman
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.
you have a real nack of not answering the question asked at all
Reply With Quote
Originally Posted by cabruntz
Bookmarks