SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-35
ALTER TABLE Statement
move-spec
sets the catalog name and these file attributes for the table or partition dest-
part:
The DSLACK, ISLACK, SLACK, EXTENT and FORMAT clauses are not supported
for a move or merge of a partition into an existing partition.
Make sure that the values you specify result in a table or partition large enough to
hold data being moved from an existing table or partition. Error 45 (File is full)
occurs if the new partition does not have enough space to store the rows
transferred. The default is the value of the corresponding attribute for the table or
partition being moved or split. For more information, see the entry for a specific
attribute.
The CATALOG option in move-spec specifies a catalog on the same node as
dest-part to contain the description of the dest-part. The default is the
current default catalog. If you do not specify CATALOG for a one-way move or a
merge operation, SQL determines the correct catalog.
If SMF is installed, the PHYSVOL option directs SQL to override SMF and move
the partition to the physical volume-name. For volume-name, specify either a
physical volume or equivalent DEFINE. Do not include the node name in your
volume name.
[ NAME operation-name ]
[ ]
WITH SHARED ACCESS [ REPORT [ TO collector | ON | OFF ] ]
[ ]
[ {COMMIT [WORK] [commit-options]} ]
[ {ROLLBACK [WORK] } ]
specifies that the partition being moved be accessible for read and write access by
DML statements throughout most of the move or split operation.
CATALOG Sets the catalog name
PHYSVOL Sets a physical volume for the new partition that overrides
SMF
EXTENT Sets extent sizes
MAXEXTENTS Sets maximum extents
FORMAT 1 |
FORMAT 2
Sets partition format.
DSLACK Sets percent of slack in data blocks
ISLACK Sets percent of slack in index blocks
SLACK Sets percent of slack in blocks if not specified by DSLACK or
ISLACK