Specifies that the data in the named partition be moved to
    the partition identified in the area-spec clause and that the
    current partition is to be dropped after the data is migrated.
    For example, this clause allows a single hashed index partition
    to be moved to a larger storage area when too many mixed area
    extends are observed.

    No other clauses may appear in the same ALTER INDEX statement.