Database Error Messages

OCI-02532

sharding and supersharding columns must form a subset key of key columns of a UNIQUE index

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.