shrink table after delete
Hi,
I want to remove some data from a Oracle table, too free up some space on hard drive.
I use delete clause with where condition to delete data, but then after i would need some shrink clause to shrink up the table as i understand.
I cant use truncate because it doesn't allow to use where clause. I need something like:
delete from table 1 where condition1;
shrink table1; --rfree up space