DEALLOCATE Clause

Deallocate an amount of space from table extents.

Syntax:

   DEALLOCATE UNUSED
   DEALLOCATE UNUSED KEEP int K
   DEALLOCATE UNUSED KEEP int M

Related Commands:

ALTER TABLE

Related Views:

DBA_EXTENTS     USER_EXTENTS
DBA_SEGMENTS    USER_SEGMENTS 
SYS_DBA_SEGS    SYS_USER_SEGS


© Copyright SS64.com 1999-2013
Some rights reserved