Database DataWarehousing (MOSC)

MOSC Banner

Materialized view refresh fails

edited Nov 24, 2016 4:00AM in Database DataWarehousing (MOSC) 5 commentsAnswered

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center