15.00 - 9253 Invalid range specified for partitioning expression caused numeric overflow. - 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)

9253 Invalid range specified for partitioning expression caused numeric overflow.

Explanation:

For a CREATE TABLE or ALTER TABLE statement, the RANGE_N partitioning expression contains a range boundary which is larger than can be expressed by the data type of the test value.

Generated By:

OPT modules.

For Whom:

End User.

Remedy:

Examine the DDL statement and verify that it is correct. Modify the partitioning expression such that none of the range boundaries in the RANGE_N expression is larger or smaller than can be represented by the data type of the test value.