DEALLOCATE Clause

Deallocate an amount of space from table extents.

Syntax:

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

Related Oracle Commands:

ALTER TABLE

Related Views:

DBA_EXTENTS     USER_EXTENTS
DBA_SEGMENTS    USER_SEGMENTS 
SYS_DBA_SEGS    SYS_USER_SEGS


 
Copyright © SS64.com 1999-2019
Some rights reserved