alter table shrink space compact/shrink space
I am planning to run the following scripts to release space in a table that has been heavily cleaned up by 'delete ..' statement.
However, I wasn't sure if I should run
"alter table .. shrink space compact' and then "alter table .. shrink space '
or just use
"alter table .. shrink space compact'
The database version we have now is 10g, but eventually, I will run the script on 11g database also. I also wonder if I need to have concerns on indexes that associated with the tables being 'shrink'.
Thank you!
Martin