I have a situation where I keep running out of space in my tablespace.
This situation is caused by my "delete from <table>" statement in a
script I am using and the space not freeing up in the table(s) like it
does in a "truncate table" command.

I am unable to do truncates on these table(s) as I need to maintain the
data in these tables. How do I get back all the freespace in these
tables without having to truncate them? What commands do I use in order
to accomplish this?

Thank you for your help in this matter!

Sean


Oracle LazyDBA home page