Oracle 26ai

ORA-02532

Cause

An attempt is being made to create a PRIMARY KEY or UNIQUE constraint in a table whose sharding or supersharding columns do not form a subset of the key columns of the UNIQUE index.


Action

Include all sharding and supersharding columns in the list of key columns of the UNIQUE index. This is required because UNIQUE constraint cannot be enforced across shards.