Hey Guys,

I have a production table which is a cluster and residing in one tablespace size of 57GB as on today. I run the process to delete records from that table, which is fine but oracle is not releasing space from the tablespce. Can you give me the possible causes of not releasing the space from the tablespace even deleting records from tables.

For example: 1 reason is re verify the PCTUSED value.

Any other cause, which will help me to learn and implement?


Thanks and Regards