Materialized view refresh fails
A materialized view refresh ('C' complete refresh, with atomic_refresh=>true) fails with
ORA-12008: error in materialized view refresh path
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
tracing the refresh, in trace file:
Error encountered: ORA-10980
Oracle support suggests to ignore the error, but the refresh fails.
Any ideas?