Unique constraint violation when refreshing MV
ORA-12048: error encountered while refreshing materialized view "SATURN"."SARCHKL" ORA-00001: unique constraint (SATURN.PK_SARCHKL) violated
I have verified that it is not a duplicate record issue.
It runs manually without issue when it fails.
Thanks,
VP