-20183   THE PARTITIONED, ADD PARTITION, ADD PARTITIONING KEY, ALTER PARTITION, ROTATE PARTITION, OR PARTITION BY RANGE CLAUSE SPECIFIED ON CREATE OR ALTER FOR table-name IS NOT VALID

A clause was specified for a statement, but the clause is not valid for the indicated table.

table-name

The name of the table.

The PARTITIONED, ADD PARTITION, ADD PARTITIONING KEY, ALTER PARTITION, and ROTATE PARTITION clauses cannot be specified on ALTER TABLE, CREATE INDEX, or CREATE TABLE in the following cases:

• The table is a non-partitioned table.
• A materialized query table is defined on this table.
• The table is in a partition-by-growth table space. (If a PARTITION BY size clause was specified on the CREATE TABLE statement, the table is created in a partition-by-growth table space.)
• The ENDING clause of the ADD PARTITION clause on the ALTER TABLE statement cannot be specified for the partition-by-growth table space.
• The ENDING clause of the ADD PARTITION clause on the ALTER TABLE statement must be specified for the range-partitioned universal table space.
• The index is defined with the BUSINESS_TIME WITHOUT OVERLAPS clause.
• The ADD PARTITIONING KEY clause cannot be specified if the table is already complete by having established either table-based partitioning or index-based partitioning.
• The ADD PARTITION clause must not be specified for an implicitly created XML table that is defined with range partitioning.
• The ROTATE PARTITION clause cannot be specified if:
  • The table definition is incomplete.
  • The table contains only one partition.