ORA-03830
sharding and supersharding columns must form a subset key of key columns of a foreign key
Cause
An attempt is being made to create a foreign key constraint in a sharded table whose sharding or supersharding key columns do not form a subset of the foreign key columns.
Action
Include all sharding and supersharding key columns in the list of foreign key columns. This is required because foreign key constraint cannot be enforced across shards.
ORA-03830
sharding columns must form a subset key of key columns of a foreign key
Cause
An attempt was made to create a foreign key constraint in a sharded table whose sharding key columns do not form a subset of the foreign key columns.
Action
Include all sharding key columns in the list of foreign key columns. This is required because foreign key constraint cannot be enforced across shards.
ORA-03830
sharding columns must form a subset key of key columns of a foreign key
Cause
An attempt was made to create a foreign key constraint in a sharded table whose sharding key columns do not form a subset of the foreign key columns.
Action
Include all sharding key columns in the list of foreign key columns. This is required because foreign key constraint cannot be enforced across shards.
