Database Error Messages

OCI-05165

Cannot have same sharding key multiple times in select list while creating sharded materialized view

Cause

Creation of sharded materialized views on sharded tables requires them to not have duplicate sharding keys.


Action

Limit the select list to have only one copy of the sharding key columns.