Storage Optimization: Reclaiming Space After Deletes

After deleting ~130,000 rows (26%) from a 500,000-row, 18MB table, the segment size stayed at 18MB, since Oracle does not release space after a DELETE. SHRINK SPACE (including CASCADE) ran successfully but changed nothing, likely due to Autonomous Database storage virtualization. I rebuilt the table with CREATE TABLE AS SELECT, cutting it from 18MB to 13MB (27.8%), verified numerically. I also recovered an accidentally dropped table with FLASHBACK from the recycle bin, and built a DBMS_SCHEDULER job that logs daily tablespace usage alerts.