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. 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