15.00 - 5747 The product of the number of partitions at each level exceeds %VSTR. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5747 The product of the number of partitions at each level exceeds %VSTR.

Explanation:

For a CREATE TABLE, if more than one partitioning expression is specified in the PARTITION BY clause, the product of the number of partitions defined by each partitioning expression must not exceed 9223372036854775807. For an ALTER TABLE statement, if more than one new partitioning expression is specified in the PARTITION BY clause or partitioning expressions of a multi-level partitioned table are altered, the product of the number of partitions defined by each new partitioning expression must not exceed 65535 if the table has a 2-byte partitioning and 9223372036854775807 if the table has 8-byte partitioning.

Generated By:

RES modules.

For Whom:

End User.

Remedy:

Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the multi-level partitioned primary index rules and re-submit the request.