15.00 - 9242 The partitioning expression references a column that is not defined for this table. - 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)

9242 The partitioning expression references a column that is not defined for this table.

Explanation:

This error occurs when an attempt is made to CREATE or ALTER a PPI table with referential integrity, and the partitioning expression includes a column belonging to the parent table.

Generated By:

OPT modules.

For Whom:

System Support Representative.

Remedy:

Rewrite the table definition so that the partitioning expression only references columns defined in the table. Partitioning on columns defined in parent tables of referential integrity references is not supported.