15.00 - 7535 Operation not allowed: %DBID.%TVMID table header has invalid partitioning. - 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)

7535 Operation not allowed: %DBID.%TVMID table header has invalid partitioning.

Explanation:

A table header is marked as invalid. This can occur due to a restore/copy of the table to another system with different hardware or operating system. This can also occur when partitioning involves character or graphic data comparisons and: i. The partitioning was created with MULTINATIONAL collation and the installed MULTINATIONAL collation had changed since the table was created. ii. The partitioning was created with CHARSET_COLL collation, and the associated character set defined in DBC.Translation has changed since the table was created, or is no longer installed. iii. The partitioning expression involves one or more Unicode character expressions or literals, and the system was backed-down to a previous minor that has a different Unicode character set definition (the later release has code points that are undefined at the previous release). In this case, the partitioning expressions need to be regenerated and updated in the table headers of the table. %TVMID indicates the table. %DBID indicates the database containing the table.

Generated By:

mscbldridcol, AMP subsystem, OPT modules

For Whom:

End User.

Remedy:

Correct the problem by using the ALTER TABLE statement with the REVALIDATE PRIMARY INDEX option. If revalidation is not an option, INSERT ... SELECT the rows into another table. <<<--DR62813-bessc