NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-32
ALTER TABLE Statement
to drop a partition that contains data, use the PARTONLY option of PURGEDATA.
See PURGEDATA Command on page P-36 for a discussion of index issues.
{[FROM KEY val [UP TO LAST KEY]] } }
{ TO dest-part [ move-spec ] } }
{ [WITH SHARED ACCESS [wsa-spec]] } }
{ }
{TO dest-part [ move-spec ] } }
{ WITH SHARED ACCESS [wsa-spec] } }
[PARTONLY] MOVE { } }
{([FROM FIRST KEY] UP TO KEY val } }
{ TO dest-part [move-spec] } }
{ [WITH SHARED ACCESS [wsa-spec]])} }
{ }
{([FROM FIRST KEY] UP TO KEY val } }
{ TO dest-part [ move-spec ], } }
{ FROM KEY val [UP TO LAST KEY] } }
{ TO dest-part [ move-spec ]) } }
moves a specified portion of the table name to a new or existing partition, dest-
part, that has the attributes described in move-spec.
You can specify dest-part with a Guardian name, a DEFINE equivalent to a
Guardian name, a node name and volume name, or a volume name only.
For more information about types of move and split operations, see Types of
reconfiguration on page A-19 in the Considerations section of this entry.
PARTONLY indicates that name is a partitioned table, one partition of which is to
be moved or split. You must include PARTONLY if name is partitioned.
val is a list of comma-separated literals (one for each column in the key) that
specifies a point at which to split the existing partition.
move-spec
sets the catalog name and the following file attributes for the table or partition
dest-part:
The DSLACK, ISLACK, SLACK, and EXTENT clauses are not supported for a
move or merge of a partition into an existing partition.
CATALOG Sets the catalog name
PHYSVOL Sets a physical volume for the new partition that overrides
ServerWare SMF
DSLACK Sets percent of slack in data blocks
EXTENT Sets extent sizes
ISLACK Sets percent of slack in index blocks
MAXEXTENTS Sets maximum extents
SLACK Sets percent of slack in blocks if not specified by DSLACK or
ISLACK