Rules for the MODIFY and MODIFY PRIMARY INDEX Options for Character Partitioning
The rules for the MODIFY and MODIFY PRIMARY INDEX options for non‑character partitioning
is documented in “General Rules for the MODIFY and MODIFY PRIMARY INDEX Clauses” on page 85) and “Rules for the MODIFY, MODIFY PRIMARY INDEX, and MODIFY Partitioning Option For Multilevel
Partitioning” on page 106 also apply to character partitioning and to the character row partitioning levels
of a column‑partitioned table or join index.
The following rules are specific to character row partitioning levels in both row‑partitioned
and column‑partitioned tables and join indexes. In the case of column‑partitioned
tables and join indexes, the rules only apply to the character row partitioning levels
of a multilevel partitioning expression.
You can specify a partitioning expression that involves character or graphic comparisons
such as =, >, <=, BETWEEN, or LIKE.
A character row partitioning expression cannot specify Kanji1or KanjiSJIS columns
or constant expressions.
A character row partitioning expression must be based on one or more columns from
the table or deterministic expressions based on the columns from the table or join
index the partitioning expression is written for.
The expressions and referenced columns in the specification of the character partitioning
expression must not have CLOB data types.
The expressions specified in a character row partitioning expression must not contain
any of the following functions.
Grouped row OLAP functions
UDFs of any kind
The expressions specified in a row partitioning expression must not contain any of
the following system‑derived columns, operators, or SELECT subqueries.