Search This Blog

Tuesday, January 24, 2012

Oracle 10g Free up Unused Table Space.

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