-20182   PARTITIONING CLAUSE clause ON stmt-type STATEMENT FOR index-name IS NOT VALID

Explanation

The values PARTITIONING clause was not accepted on CREATE or ALTER INDEX statement for one of the following reasons:
  • On ALTER INDEX, if the table uses table-based CONTROLLED partitioning, or if the index is a partitioning index created in Version 8 or later releases.
  • On CREATE INDEX, values partitioning attributes were specified on a previous CREATE or ALTER TABLE statement for the table.
  • On CREATE INDEX, if the partitioning scheme of the index is predetermined by that of the underlying data.
  • On ALTER TABLE, when altering partition limit key values, if there are any large object (LOB) columns in the table.

System action

The statement cannot be processed.

Programmer response

Change the name of the index to an index for which the values partitioning clause would be valid, and resubmit the statement.

SQLSTATE

530A2