Saturday, October 13, 2012

7535: Operation not allowed: table header has invalid partitioning.


This can occur due to a restore/copy of the table to another system with different hardware or operating system. In this case, the partitioning expressions need to be regenerated and updated in the table headers of the table. 

Example:

SELECT Failed. 7535: Operation not allowed: MTD_DB.MTD_MSTR table header has invalid partitioning. 

solution to this is validating table header with primary index of table.
For that we can ALTER the TABLE with the REVALIDATE PRIMARY INDEX option.

here we go... command is ..


alter table Mtd_tb.mtd_mstr revalidate primary index;




No comments:

Post a Comment