-661   object-type object-name CANNOT BE CREATED ON PARTITIONED TABLE SPACE tspace-name BECAUSE THE NUMBER OF PARTITION SPECIFICATIONS IS NOT EQUAL TO THE NUMBER OF PARTITIONS OF THE TABLE SPACE

Explanation

The object-name definition is incorrect for one of the following reasons:
  • If object-type is INDEX, the CREATE INDEX statement for the cluster index on a partitioned table (that is, a table residing in a partitioned table space) does not contain the same number of partition specifications as there are partitions in the table space. The definition for the cluster index for a partitioned table must contain exactly as many partition specifications as there are partitions in the table space in which that table resides. Also, the partition numbers must be valid and unique.
  • If object-type is TABLE, the number of partitions that is specified in the partitioning clause of the CREATE TABLE statement differs from the number of partitions in the table space in which the table is being created.

System action

The statement cannot be processed. The specified cluster index or table was not created.

Programmer response

Examine the definition of the partitioned table space to determine how many partitions have been specified. Correct the syntax of the CREATE INDEX or CREATE TABLE statement to provide the proper number of partition specifications.

SQLSTATE

53036