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.
OCI-02532
sharding columns must form a subset key of key columns of a UNIQUE index
Cause
An attempt was made to create a PRIMARY KEY or UNIQUE constraint in a table whose sharding columns do not form a subset of the key columns of the UNIQUE index.
Action
Include all sharding columns in the list of key columns of the UNIQUE index. This is required because UNIQUE constraint cannot be enforced across shards.
OCI-02532
sharding columns must form a subset key of key columns of a UNIQUE index
Cause
An attempt was made to create a PRIMARY KEY or UNIQUE constraint in a table whose sharding columns do not form a subset of the key columns of the UNIQUE index.
Action
Include all sharding columns in the list of key columns of the UNIQUE index. This is required because UNIQUE constraint cannot be enforced across shards.