Just to note if anyone need,
Difference between shrink space/compact/cascade
Shrink space compact -Just moves the rows from end of the table to beginning of the table. Does not drop the high water mark of the table.
Shrink space - Moves the rows from end of the table to the beginning of the table and also drop the high water mark of the table. This action has been split into two , first move the rows and then lock the table and then move high water mark
Shrink space cascade - Rebuild indexes of that table and drop the high water mark of the table too.
-Thanks
Geek DBA
Follow Me!!!