ORA-05164
Cannot create sharded materialized view when sharded tables are joined on non-sharding keys
Cause
Creation of sharded materialized views on sharded tables requires them to be joined on sharding keys.
Action
Join the sharded tables on the sharding keys.