MAP PARTITION

MAP PARTITION — create an association between a table partition name and a storage group name

Syntax

MAP PARTITION partition_name STORE IN storage_group_name

Description

The MAP PARTITION command creates an association between a table partition name and a storage group name. This establishes a storage group name for subsequent partitions that do not otherwise establish a storage group name. The MAP PARTITION command has no effect on existing partitions. See Example 2 below.

Note: For each table created with a CREATE TABLE statement, the STORE IN clause associated with that statement takes precedence when used in conjunction with a MAP PARTITION statement and STORE IN clause.

For information on create storage groups see Managing Storage Groups. To remove the mapping from a table partition name to a storage group, see UNMAP PARTITION.

Parameters

Examples