Teradata Database Message 7535 - 17.10 - 7535 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Operation not allowed: %DBID.%TVMID table header has invalid partitioning.
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.
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.