-623 CLUSTER IS NOT VALID FOR table-name
Explanation
A table can have only one cluster index, and hash organization cannot be used when a table has a clustering index.
- table-name
- The name of the table.
The CLUSTER option cannot be specified for one of the following reasons:
- A CREATE INDEX statement attempted to create a cluster index on the specified table, but a clustering index already exists on the table.
- An ALTER INDEX statement specified the CLUSTER clause, but there is already a clustering index defined for the table.
System action
The statement cannot be processed.
Programmer response
Check to determine the identity and validity of the existing cluster index on or use of hash organization with the object table. Alternatively, consider creating the index without the CLUSTER attribute.
SQLSTATE
55012
