The following operations will shrink the table and reset the high water mark. EXAMPLE: SQL> alter table hr.employees enable row movement; Table altered. SQL> alter table hr.employees shrink space cascade; Table altered. The above command will free up unused space from the table along with its index segments.
0 comments:
Post a Comment