-20300 THE LIST OF COLUMNS SPECIFIED FOR THE clause CLAUSE IS NOT ALLOWED IN COMBINATION WITH THE LIST OF COLUMNS FOR THE PARTITIONING KEY FOR THE TABLE.
Explanation
The list of columns that was specified for a clause is not valid when used with the list of columns of the partitioning key for the table.
- clause
- The clause that was specified
When the PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE clauses are used on the same table and the column list for the PARTITION BY RANGE clause includes a single column, the hash key must have that column as its first hash key column
When the PARTITION BY RANGE and ORGANIZE BY HASH clauses are used on the same table, the column list for the PARTITION BY RANGE clause must be identical to or be a subset of the column list for the ORGANIZE BY HASH clause and the column names must be in the same order.
System action
The statement cannot be processed.
User response
Change the list of columns in the appropriate clause or clauses.
SQLSTATE
428GD
